I need help with a "LOOKUP" formula.

serge

Well-known Member
Joined
Oct 8, 2008
Messages
1,280
Office Version
  1. 2007
Platform
  1. Windows
Hi everyone,

I need help with a Lookup formula.

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

3.PNG


Then I have this reference table.

1.PNG


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
Joined
Apr 29, 2016
Messages
458
Office Version
  1. 2016
Try this:

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

maabadi

Well-known Member
Joined
Oct 22, 2012
Messages
2,681
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
or Try:
Excel Formula:
=LOOKUP(D7*1,Sheet2!$B$6:$C$105*1)
 

serge

Well-known Member
Joined
Oct 8, 2008
Messages
1,280
Office Version
  1. 2007
Platform
  1. Windows
Thank you very much to both of you for taking the time to help me, I really appreciate it.
Serge.
 

maabadi

Well-known Member
Joined
Oct 22, 2012
Messages
2,681
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
You're Welcome & Thanks for follow-up.
 

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top