Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VLookup function to search an entire workbook | Excel Worksheet Functions | |||
a search function | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Search function | Excel Discussion (Misc queries) | |||
Search function using commas | Excel Worksheet Functions |