• 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

Shabbo

Member
Dear Sir,
Please help me to find why Value is coming zero in SHEET2 C3.
Vlookup is not working in this case.
Please let me know error.
 

Attachments

Peter Bartholomew

Well-Known Member
My way of working would be alien to you but it shows that the first value returned in the second row is a perfectly valid blank cell and not #N/A.

63367
 

Shabbo

Member
Try this formula
Code:
=IFERROR(CHOOSE((VLOOKUP(A2,SHEET1!B:C,2,0)=0)+1,VLOOKUP(A2,SHEET1!B:C,2,0),VLOOKUP(B2,SHEET1!B:C,2,0)),"")
Dear Sir,
I tried this formula but getting error :
=IFERROR(CHOOSE(VLOOKUP(N2,'CP (2)'!B:N,13,0)=0)+1,VLOOKUP(N2,'CP (2)'!B:N,13,0),VLOOKUP(O2,'CP (2)'!B:N,13,0)),"")
 

p45cal

Well-Known Member
Try in C2:
Code:
=IF(OR(ISERROR(VLOOKUP(A2,SHEET1!B:C,2,0)),VLOOKUP(A2,SHEET1!B:C,2,0)=0),VLOOKUP(B2,SHEET1!B:C,2,0),VLOOKUP(A2,SHEET1!B:C,2,0))
and copy down. (salim hasan's solution gives similar results.)
 

bosco_yip

Excel Ninja
Or.................

=IFERROR(IFERROR(1/(1/VLOOKUP(A2,SHEET1!B:C,2,0)),VLOOKUP(B2,SHEET1!B:C,2,0)),"")

Regards
Bosco
 
Top