# Vlookup

#### Shabbo

##### Member
Dear Sir,
Vlookup is not working in this case.

#### Attachments

• 12.8 KB Views: 8

#### 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