View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
the_intern the_intern is offline
external usenet poster
 
Posts: 2
Default 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