| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookups and if statement
Bob Bridges wrote:
While you're answering smartin's very relevant questions, allow me to point out that the sample formula you typed out for us won't work. Even assumping an extra bang ("!"), like this: VLOOKUP(A2,Tab1!A2:B50,3) ...the third argument says to take a value from the third column, yet you specified only a two-column table. In my version of Excel, at least, this returns the #REF error. Bob, Thanks for looking over my overlooking the obvious (^: |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dependent vlookups - nested vlookups (maybe) | Excel Worksheet Functions | |||
| multiple vlookups in one statement | Excel Worksheet Functions | |||
| Vlookups | Excel Worksheet Functions | |||
| VLOOKUPS | Excel Worksheet Functions | |||
| vlookups | Excel Discussion (Misc queries) | |||
Hybrid Mode
