Thread: Look up value
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Trevor Shuttleworth Trevor Shuttleworth is offline
external usenet poster
 
Posts: 1,089
Default 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