| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to get value from a table satisfying two conditions
With data as below try
=VLOOKUP("c",A1:D5,MATCH(2,A1:D1,0),0) Col A Col B Col C Col D 1 2 3 a x x x b x x x c x x x d x x x -- Jacob "Dhirendra Kumar" wrote: I need assistance to get information from a table satisfying two varibles ie if row and column values are given how to get the corresponding value from the table? ie combination of Vlookup and Hlookup |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if then statement to return text from cells satisfying condition | Excel Worksheet Functions | |||
| Calculate Filtered cells with satisfying toomany arguments.. | Excel Worksheet Functions | |||
| Satisfying 2 conditions and lookup from a 3rd column to return a v | Excel Worksheet Functions | |||
| Lookup table for two conditions | Excel Worksheet Functions | |||
| using sumif formula: but requiring satisfying 2 if statements | Excel Worksheet Functions | |||
Threaded Mode
