Macro to match values in an array.
=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 |
All times are GMT +1. The time now is 09:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com