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
|