I need help with a "LOOKUP" formula.

[serge]

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.

 

[Phuoc]

Try this:

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

 

[maabadi]

or Try:

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

 

[serge]

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

 

[maabadi]

You're Welcome & Thanks for follow-up.