| Home |
| Search |
| Today's Posts |
|
#6
|
|||
|
|||
Quote:
The reason about +1 is simple. In this case the Function MATCH starts searching at column 2. The Function VLOOKUP always starts numbering columns as column 1. As the used formula is indexed, you need to add +1 to capture the right answer. Try to remove the +1 and observe the answer. It will be the same value of a previous column. Is it OK? Have a nice day.
__________________
I hope it can help you. Best regards, Marcilio Lobão --------------------------- Belo Horizonte, Brazil |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hardcore formula heroes - Combination Vlookup and multiple IF form | Excel Worksheet Functions | |||
| Matrix lookup/mulitple criteria lookup | Excel Discussion (Misc queries) | |||
| Lookup valid combination of multiple cells | Excel Worksheet Functions | |||
| Matrix Lookup | Excel Discussion (Misc queries) | |||
| Lookup in Matrix | Excel Worksheet Functions | |||
Threaded Mode
