Lookup and match corresponding value

Lookup a match of every value of C in column A,if it matches then print Corresponding value in D

Example:

Example:
C1=89.5 is A5=89.5 both matches so D1=715.1

Please see attached sheet.

Thanks in advance

Put this formula in D2:

=IFERROR(VLOOKUP(C2,A:B,2,0),"")

then copy down.

Hope this helps.

Pete

thanks a lot

You're welcome - thanks for the rep.

If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Pete