Multiple VLOOKUPS


A

Alex

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,'Data
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
 
Ad

Advertisements

S

Sheeloo

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,'Data
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?
 
A

Alex

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.
 
Ad

Advertisements

A

Alex

No I'm using multiple tables to get results for different teams so have a
number of them from column B - K and then another set from column M - T with
column M being where the lookup value is. My tables in columns B - K work
fine as they only use one argument (ISERROR) where these need to be able to
say if the result is an error or if it's "0". Hope someone can help as I keep
trying different things with no luck.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Vlookup Help 0
#VALUE! 10
Need Help with VLOOKUP 4
Count If Vlookup Array 3
changing color of answer 1
=IF(ISERROR(VLOOKUP(A3,contacts!B:I,5,FALSE)), " ", VLOOKUP(A3,con 4
VLookup Formula 5
Formula Question 3

Top