Bob Phillips
12/13/2006 6:08:00 PM
=INDEX(D:D,MATCH(B2,E:E,0)
in A2. Copy down
--
---
HTH
Bob
(change the xxxx to gmail if mailing direct)
"Wester" <Wester@discussions.microsoft.com> wrote in message
news:97B03A64-C3FE-42EA-905F-379B378BF588@microsoft.com...
> 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