Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a table with three variables. I need to extract data based on the
value of three variables. For example: Column 1 Column2 Column3 Column4 and so on... 4 5 10 8 8-0.25 8-0.375 10 12 10-0.25 10-.0375 12 8 9-0.188 9-0.375 12 12 11-0.375 12-0.25 Based on the above data, I would like to extract data when column1 is 10, column2 is 12 and value in the first row is 5. The answer should be 10-0.375. I have tried index, match and vlookup. They only give answer for two variables. Please help. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Identifying numbers froma text | Excel Discussion (Misc queries) | |||
Extracting Numbers froma Text String | Excel Worksheet Functions | |||
Extracting a Single Worksheet froma Mutipage Workbook | Excel Discussion (Misc queries) | |||
lookup value froma filtered list | Excel Worksheet Functions | |||
Copying and Pasting froma Userform | Excel Programming |