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