If formula help
On Aug 5, 8:47*am, Juan wrote:
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
|