| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help With VLOOKUP
This is part of a formula I am working on:
if(or(iserror(vlookup(a1,Exceptions!$a:$c,3,0)),vl ookup(a1,Exceptions!$a :$c,3,0)=""),"Do step A","Do step B") The formula does not evaluate correctly with the second VLOOKUP when the value in A1 is not present in the Exceptions tab. This is because the OR function evaluates to: OR(TRUE,#N/A), and therefore the final output is also "#N/A". How can I corrct this? -- tb |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
| Vlookup problem - unable to get the vlookup property | Excel Programming | |||
| using a vlookup to enter text into rows beneath the vlookup cell | Excel Programming | |||
| Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
| Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
Threaded Mode
