Look up value

N

Not Excelerated

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
 
T

Trevor Shuttleworth

Chris

The formula for cell B2 in Row 2 would be:

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

Regards

Trevor
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup Help, Please! 1
Need help with a lookup or if statement 4
Looking up for value vertically and horizontally simultaneously 1
calculating probabilty of x number of successes with multiple tria 15
Complex 2 table formula 5
Match and Lookup 1
Looking a value up for a 1
Having problem with referencing 6

Top