| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with VLOOKUP when i try to look for more than 1 criteria
COLUMN 1 COLUMN2 TARGET cloumn3 column4 TARGET
A 20 A 20 AA B 30 B 30 BB S 23 F 24 FF D 23 D 23 DD G 12 J 65 JJ F 24 H 25 HH D 23 A 20 S 23 D 20 F 24 G 12 H 25 J 65 K 65 L 43 J 65 G 12 In the above column named 'TARGET' i want to apply Vlookup. for eg:-( where A=20 in COLUMN1 & COLUMN2, return 'AA' from 'TARGET' in 'TARGET') similarly for all. i hope i am clear with my question. thanks, varun |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup with 4 Criteria | Excel Discussion (Misc queries) | |||
| using vlookup for more than 1 criteria | Excel Worksheet Functions | |||
| VLOOKUP or IF with many criteria | Excel Worksheet Functions | |||
| vlookup with two criteria | Excel Worksheet Functions | |||
| two criteria in a vlookup | Excel Worksheet Functions | |||
Threaded Mode
