• 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

  • Mydata.xlsx
    15.3 KB · Views: 7
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