duplicate numbers wrong output data, help!!

Tartesos

Board Regular
Joined
Feb 3, 2011
Messages
109
Ok, this is he formula im using:
=IF(ISNUMBER(LOOKUP(9.99999999999999E+307,FIND(data!$B$4:$B$2488,imput!B133))),T(LOOKUP(9.99999999999999E+307,FIND(data!$B$4:$B$2488,imput!B133),data!$AH$4:$AH$2488)),"")

So, when i type a ref. number on B133 on the imput sheet, this formula should go to AH4:AH2488 and select the correct output data that will be display on the correct cell(AH 133) from the imput sheet.
This is not hapening. This formula is also use from 4 to 2488.
Is true that the numbers that are in the imput cells 133 and 134 are the same but the information on the AH is not the same. In our company we can use duplicates ref. number but there is a number of differences that are found on the AH column from the data sheet.

But what is also very weird is that if I add the information on the cell 134 from the AH column on the data sheet, that information will be display on the 133 and 134 with the same value, the one on the AH134.
I was wondering if there is anything it may be wrong on the formula or it is something to do with the fact that the numbers are duplicate.
anyone can bring some light to this ? ...

Thanks
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Forum statistics

Threads
1,224,527
Messages
6,179,328
Members
452,907
Latest member
Roland Deschain

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
Back
Top