• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need help with VLOOKUP

C

CHAD P

New Member
=VLOOKUP(A2,Sheet3!$B$2:$C$90,2,FALSE)
If the Value returned for the VLOOKUP in column B is "#N/A", I want it to display the last
Numerical value of "1.135" from cell B21 for cells B2 through B20. Then for cells B22 through B84 the "#N/A" should be
value of "0.939" from cell B85.

Is there a better function or improved VLOOKUP argument that could accomplish this without having to input the numbers manually?

File attached.

Thank you.
 

Attachments

Hi Chad P,

Use below formula in B2 and copy down to last row:
=IFERROR(VLOOKUP(A2,Sheet3!$B$2:$C$90,2,FALSE),B3)

Now, you need to decide or suggest what you want to do if the last value is also resulting #N/A.

Regards,
Prasad DN
 
You must log in or register to reply here.
Back
Top