Vlookup

[Shabbo]

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.

 

[salim hasan]

Try this formula

=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)),"")

 

[p45cal]

why Value is coming zero in SHEET2 C3.

It's coming up 0 because there's nothing in cell C21 of Sheet1!

 

[Peter Bartholomew]

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.

 

[Shabbo]

Try this formula

=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)),"")

 

[Shabbo]

It's coming up 0 because there's nothing in cell C21 of Sheet1!

Dear Sir,
If you see then Helper value MMH4 JU 355743715 is available in C32 and I wanted to lookup that value.

 

[p45cal]

Try in C2:

=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]

Or.................

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

Regards
Bosco