View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
ALEX ALEX is offline
external usenet poster
 
Posts: 493
Default Multiple VLOOKUPS

I'm using 2003. I've just tried that and now it's back to resulting in an #NA
error. It accepts the formula just doesn't seem to be answering the arguments.

"Sheeloo" wrote:

Try
=IF(IF(ISERROR(VLOOKUP($M11,'Data
Table'!$B$2:$S$350,8,FALSE)),"",VLOOKUP($M11,'Data
Table'!$B$2:$S$350,8,FALSE))=0,"",VLOOKUP($M11,'Da ta
Table'!$B$2:$S$350,8,FALSE))

I have put the ISERROR check inside
IF(ISERROR(VLOOKUP($M11,'Data
Table'!$B$2:$S$350,8,FALSE)),"",VLOOKUP($M11,'Data Table'!$B$2:$S$350,8,FALSE)

... and =0 test outside. Once this works then you can tweak it...

Which version are you using? 2003?

"Alex" wrote:

Hi, I'm trying to use IF & VLOOKUP formulas to find data in a spreadsheet but
I can't seem to work with multiple arguments. This is the formula I'm using:

=IF(ISERROR(VLOOKUP($M11,'Data Table'!$B$2:$S$350,8,FALSE)),"",IF(VLOOKUP($M11,'D ata
Table'!$B$2:$S$350,8,FALSE)=0,"",VLOOKUP(M11,'Data
Table'!$B$2:$S$350,8,FALSE)))

I've replaced my source data location with Data Table to make it shorter.
What I'm looking for it to do is show the result of the VLOOKUP when the
result doesn't equal an error or "0". I've tried OR as well and that doesn't
seem to work either. Whatever the outcome I get blank cells.

Thanks