ExcelBanter - Look up value

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Look up value (https://www.excelbanter.com/excel-worksheet-functions/159833-look-up-value.html)

Not Excelerated[_2_]

Look up value

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

Trevor Shuttleworth

Look up value

Chris

The formula for cell B2 in Row 2 would be:

=VLOOKUP(A2,C:D,2,FALSE)

Regards

Trevor

"Not Excelerated" wrote in
message ...
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 12:00 PM.