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