If formula help

[Juan]

Hello all,
here's what I'm trying to do:
If part# in Column E is in column A, then pull the data from column B into
column F, if no match, then leave blank or put no match.
Here's what I tried doing:
If (E:E=A:A, B:B:,"no match") but since column E and A do not have same
amount of rows, the formula doesn't work.
Would appreciate help with formula.
Thank you,
J

 

[james.billy]

Hello all,
here's what I'm trying to do:
If part#  in Column E is in column A, then pull the data from column B into
column F, if no match, then leave blank or put no match.
Here's what I tried doing:
If (E:E=A:A, B:B:,"no match")  but since column E and A do not have same
amount of rows, the formula doesn't work.
Would appreciate help with formula.
Thank you,
J

Hi,

Probably more a question for functions than the programming forum but
you could use this formula, a bit more complicated than your
original...

=If(Iserror(match(E1,A:A,0)),"no match",Index(B:B,Match(E1,A:A,0),1))

So this assumes your putting your formula into F1, to look at cell E1,
firstly it will see if E1 exists in column A if doesn't then it
returns "no match", if it does it uses the index function to return
the same row of column B that has the match in column A.

Hopefully this makes sense,

James

 

[Dick Kusleika]

Hello all,
here's what I'm trying to do:
If part# in Column E is in column A, then pull the data from column B into
column F, if no match, then leave blank or put no match.
Here's what I tried doing:
If (E:E=A:A, B:B:,"no match") but since column E and A do not have same
amount of rows, the formula doesn't work.
Would appreciate help with formula.
Thank you,
J

=IF(ISNA(VLOOKUP(E?,A1:B1000,2,FALSE)),"",VLOOKUP(E?,A1:B1000,2,FALSE))

 

[Juan]

Hello Dick and James,
both of you Thanks a lot. I tested both formula and seems to work fine.

I really appreciated the help.
Thanks again,
J