| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can I use =if with vlookup statements
You might have to put VALUE( ) around your RIGHT formula to convert it
to a number, and as Kevin has pointed out the widths of your ranges are inconsistent with the column number you are trying to return data from. Hope this helps. Pete |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup and if statements | New Users to Excel | |||
| VLOOKUP Limitations | Excel Worksheet Functions | |||
| VLOOKUP + IF STATEMENTS | Excel Discussion (Misc queries) | |||
| vlookup data hidden within worksheet | Excel Worksheet Functions | |||
| VLOOKUP statements | Excel Discussion (Misc queries) | |||
Hybrid Mode
