| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Vlookup with 2 columns
Excel 2000
Is it possible to do a verticle looking comparing 2 columns rather than just 1? Thanks. Gary |
|
#2
|
|||
|
|||
|
=INDEX(F1:F100,MATCH(C1&C2,D1:D100&E1:E100,0))
it is an array formula, so commit with Ctrl-Shift-Enter. -- HTH Bob Phillips "Gary H" wrote in message ... Excel 2000 Is it possible to do a verticle looking comparing 2 columns rather than just 1? Thanks. Gary |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I Double Conditional vlookup for 3 columns? | Excel Worksheet Functions | |||
| vlookup for multiple columns | Excel Worksheet Functions | |||
| vlookup for multiple columns | Excel Worksheet Functions | |||
| Is there a way to do a vlookup to look up two columns versus one? | Excel Worksheet Functions | |||
| Moving columns with VLOOKUP formulas | Excel Worksheet Functions | |||
Linear Mode
