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

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