# I need help with a "LOOKUP" formula.

#### serge

##### Well-known Member
Hi everyone,

I need help with a Lookup formula.

I have this table data, that group 2 digit 2 by 2.

Then I have this reference table.

Then when I use my Lookup formula.

=LOOKUP(D7,Sheet2!\$B\$6:\$C\$105)

it return " #N/A ".

The problem is because of the "0" in front of the digit, so how can I make the formula accept the "0" ?
Because I can't really change my original data.

Thank you.
Serge.

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.

#### Phuoc

##### Active Member
Try this:

=LOOKUP(TEXT(D7,"00"),Sheet2!\$B\$6:\$C\$105)

##### Well-known Member
or Try:
Excel Formula:
``=LOOKUP(D7*1,Sheet2!\$B\$6:\$C\$105*1)``

#### serge

##### Well-known Member
Thank you very much to both of you for taking the time to help me, I really appreciate it.
Serge.

##### Well-known Member
You're Welcome & Thanks for follow-up.

Replies
1
Views
212
Replies
15
Views
279
Replies
9
Views
154
Replies
8
Views
147
Replies
1
Views
86

1,148,018
Messages
5,744,355
Members
423,863
Latest member
teehexcel

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back