| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLookup vs. Match/Index
Can someone please explain the difference between Vlookup and Match/Index.
The formula I am using is a vlookup (see below)--but I am wondering if using another formula (match/index?) would be better. The formula works but if a column is inserted it would skew the result. Any advice? =IF(ISERROR(VLOOKUP($B15,Gd.5U1!$B$14:$BC$153,26,F ALSE)),"",VLOOKUP($B15,Gd.5U1!$B$14:$BC$153,26,FAL SE)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| not sure if i need vlookup or match/index | Excel Worksheet Functions | |||
| VLOOKUP, MATCH, INDEX HELP! | Excel Worksheet Functions | |||
| VLOOKUP vs INDEX and MATCH | Excel Discussion (Misc queries) | |||
| index Match, or Vlookup Match.. | Excel Worksheet Functions | |||
| Need Help with Index and Match or Vlookup | Excel Worksheet Functions | |||
Threaded Mode
