Lookup Help, Please!
Help and Hello!
I'm trying to look up and match a value from each row in column A to a value in column C and return the associated value for that row in column B. Example: A B C D 14 0.1 14 0.1 14 0.1 15 0.2 15 0.2 16 0.3 15 0.2 17 0.5 16 0.3 18 0.8 Thanks so much in advance!!! Chris |
Lookup Help, Please!
Try one of these.
Entered in B1: =VLOOKUP(A1,C$1:D$5,2,0) =INDEX(D$1:D$5,MATCH(A1,C$1:C$5,0)) Copy down as needed. -- Biff Microsoft Excel MVP "Not Excelerated" wrote in message ... Help and Hello! I'm trying to look up and match a value from each row in column A to a value in column C and return the associated value for that row in column B. Example: A B C D 14 0.1 14 0.1 14 0.1 15 0.2 15 0.2 16 0.3 15 0.2 17 0.5 16 0.3 18 0.8 Thanks so much in advance!!! Chris |
All times are GMT +1. The time now is 07:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com