=INDEX(D:D,MATCH(B2,E:E,0)

in A2. Copy down

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Wester" wrote in message
...
Hi,

Needing help with macro and which formula I should use. I am not even
sure
if I am using the right terminology?

I need a macro to match my column B value with another table (D:E) and
then
place the matching Fruit code (TBL_Code) into column A. So, when B=E put
D
into A.

A B C D E
CODE FRUIT QTY TBL_Code TBL_Fruit
Banana 4 APPL Apple
Apple 8 BANA Banana
Orange 3 CHRR Cherries
ORNG Orange

Any help would be appreciated.

Thanks

-Wesley