Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() Dear all I would like to create a lookup or index that finds a particular entry by column and row. This is my data part number month1 month2 month3 month4 123 10 20 30 40 456 50 60 70 80 On another sheet I have two selection cells, I have selected part number 123 and month 2, in another cell I want to see the result 20. I hope this makes sense. I really appreciate any help as I am relatively new to excel Kathryn |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lookup Multiple Criteria return One answer | Excel Worksheet Functions | |||
Lookup with Multiple Criteria | Excel Discussion (Misc queries) | |||
Multiple criteria LOOKUP | Excel Worksheet Functions | |||
Lookup: 2 criteria | Excel Discussion (Misc queries) | |||
Conditional Lookup on Multiple Criteria | Excel Worksheet Functions |