Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

SELECT WHERE

Hi folks!

I have a sheet with columns A, B and C and liked to have in E1 the value of the cell in C where the cells in A and B have some specific values. In SQL I'd do:

select C from Sheet1 where A='foo' and B='bar'

How can this be done in Calc?