Excel formula won't work (if, match, iserr, vlookup)


M

midget

Hi
I need help with the following formula:
=if(=iserr(=match(a2,LIST,0))=0,=vlookup(a2,DATA,1),0)
Excel says there is something wrong with my formula but won't say what.

What is it doing?
I have a list of data in columns B, C and D that are unique to the value in
A. Basically on Sheet 2 cell B2 I want to lookup a value (in A2) from the
selected range (LIST on Sheet1 ie: A2:A100) and if it is there, then I want
the cell (B2) to return the corresponding value from column 1 in the range
DATA (A2:D100). if it is not there then I want it to return a value of n/a or
"#n/a" (anything to indicate it isn't there).

I have moved over from Lotus 123 (cause I found it difficult to use) and the
formula I use (sucessfully) in 123 is:
@if(@iserr(@match(a2,$list,0))=0,@vlookup(a2,$data,1),0)
 
Ad

Advertisements

R

Ronx

midget explained :
Hi
I need help with the following formula:
=if(=iserr(=match(a2,LIST,0))=0,=vlookup(a2,DATA,1),0)
Excel says there is something wrong with my
formula but won't say what.
What is it doing?
I have a list of data in columns B, C and D
that are unique to the value in A. Basically
on Sheet 2 cell B2 I want to lookup a value (in
A2) from the selected range (LIST on Sheet1
ie: A2:A100) and if it is there, then I want
the cell (B2) to return the corresponding value
from column 1 in the range DATA (A2:D100). if
it is not there then I want it to return a
value of n/a or "#n/a" (anything to indicate
it isn't there).
I have moved over from Lotus 123 (cause I found
it difficult to use) and the formula I use
(sucessfully) in 123 is:
@if(@iserr(@match(a2,$list,0))=0,@vlookup(a2,$data,1),0)

I suggest you ask this question in a forum or
newsgroup where Excel experts abound. FrontPage
is for building web sites, not spreadsheets.
 
Ad

Advertisements

H

Helpful person

Hi
I need help with the following formula:
=if(=iserr(=match(a2,LIST,0))=0,=vlookup(a2,DATA,1),0)
Excel says there is something wrong with my formula but won't say what.

What is it doing?
I have a list of data in columns B, C and D that are unique to the value in
A. Basically on Sheet 2 cell B2 I want to lookup a value (in A2) from the
selected range (LIST on Sheet1 ie: A2:A100) and if it is there, then I want
the cell (B2) to return the corresponding value from column 1 in the range
DATA (A2:D100). if it is not there then I want it to return a value of n/a or
"#n/a" (anything to indicate it isn't there).

I have moved over from Lotus 123 (cause I found it difficult to use) and the
formula I use (sucessfully) in 123 is:
@if(@iserr(@match(a2,$list,0))=0,@vlookup(a2,$data,1),0)

Too many = signs. You only need the first.

www.richardfisher.com
 

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

Top