• 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.

VLOOKUP IS NOT WORKING- GIVING n/a

Hello Experts,

I want to bring the value from sheet two both vendor name and vendor number to sheet 1, but Voolup is not working.


I would highly appreciate if someone can help me with this error and report.

Regards,
Nitika Manhas
 

Attachments

p45cal

Well-Known Member
Try in Sheet1 cell C2 the array-entered formula:
Code:
=IFERROR(VLOOKUP(A2&"",TRIM(Table1),2,FALSE),"")
Array-entering means committing the formula to the sheet using Ctrl+Shift +Enter and not just Enter. Then copy down.
 

bosco_yip

Excel Ninja
Try,

In Sheet2, select all data in Column A >> "Text to Columns.. ">> Finish

Then,

Sheet1 Column C formula will work.

Regards
Bosco
 
Last edited:

Somendra Misra

Excel Ninja
Hello Experts,

I want to bring the value from sheet two both vendor name and vendor number to sheet 1, but Voolup is not working.


I would highly appreciate if someone can help me with this error and report.

Regards,
Nitika Manhas
Hi,

In your original formula you are trying to match the lookup value against table. Now VLOOKUP checks in the first column of the table which does not contains those values, they are in column 2 of the lookup array. So that is the reason you are getting errors. Better use Index + Match, as below:
=INDEX(Sheet2!$A$2:$A$602,MATCH([@[MANDATORY
]],Sheet2!$B$2:$B$602,0))
Regards.
 
Top