Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
on sheet2, i have the following table col1 col2 col3 A 1 10 A 2 11 B 1 20 B 2 25 C 1 30 C 2 32 .... on sheet1, i have the following table col1 col2 col3 A 2 B 1 A 1 C 1 i would like in col3 the result of the search...something like research on sheet 2 the couple sheet1:col1 and sheet1:col2 if found sheet1:col3 = result of research this exist vis LOOKUP function, but it does not allow a research based on 2 parameter... how can i do it ? thanks a lot for help Maileen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lookup funtion: column index number (third parameter) | Excel Worksheet Functions | |||
Cell contents as the 'lookup value' parameter in HLOOKUP function | Excel Discussion (Misc queries) | |||
Function parameter description | Excel Programming | |||
Excel VBA Function Parameter Overwritten | Excel Programming | |||
Function parameter description | Excel Programming |