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

• 12.8 KB Views: 7

salim hasan

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

Attachments

• 19.4 KB Views: 7
• herofox

p45cal

Well-Known Member
why Value is coming zero in SHEET2 C3.
It's coming up 0 because there's nothing in cell C21 of Sheet1!

• Shabbo

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

Shabbo

Member
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

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