Search function.
Hello everybody,
does anyone know what funtion to use when searching for a value in a
given excel file using the values in TWO COLUMNS together as a one
unique search "key"?
If we think SQL it might have been something like this
SELECT excelcell
WHERE thisexcelsheet.A1 = thatexcelsheet.columnA1
AND thisexcelsheet.columnB1 = thatexcelsheet.columnB1
I know that was badly explained but if anyone understood what I´m
after, feel free to help me out ;)
Thanks!
Havard
|