If formula help
 

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

If formula help
 

On Mon, 4 Aug 2008 18:47:01 -0700, 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

=IF(ISNA(VLOOKUP(E?,A1:B1000,2,FALSE)),"",VLOOKUP( E?,A1:B1000,2,FALSE))
--
Dick Kusleika
Microsoft MVP-Excel
http://www.dailydoseofexcel.com

If formula help
 

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

"Dick Kusleika" wrote:

On Mon, 4 Aug 2008 18:47:01 -0700, 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

=IF(ISNA(VLOOKUP(E?,A1:B1000,2,FALSE)),"",VLOOKUP( E?,A1:B1000,2,FALSE))
--
Dick Kusleika
Microsoft MVP-Excel
http://www.dailydoseofexcel.com