Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple VLOOKUPS
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple VLOOKUPS
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple VLOOKUPS
Is your Cell M11 Value available in Col B ?
On Oct 23, 6:59*pm, 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple VLOOKUPS
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 "muddan madhu" wrote: Is your Cell M11 Value available in Col B ? On Oct 23, 6:59 pm, 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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple VLookups - Can anyone help me please? | Excel Discussion (Misc queries) | |||
Sum a row of multiple vlookups | Excel Worksheet Functions | |||
Multiple Vlookups | Excel Worksheet Functions | |||
multiple vlookups | Excel Worksheet Functions | |||
multiple vlookups | Excel Worksheet Functions |