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