Vlookup help cross referencing cell against another sheet to return value of another cell

[Alex p h]

Can someone please help I’m trying to make a order sheet that translates alternative part numbers to my part numbers. I have a full list of the numbers in one sheet and in main sheet I’m trying to use Vlookup to find the exact match of what I type in to a cell from the other sheet and if is found then returns what is in column a in that row it has been found in, but it just won’t work for some reason. Any help would be greatly appreciated

 

[etaf]

yes, but its not just that 1 part number you are thinking about is it , hence reference to other part numbers with zero's in
like
04G-05FSX90-046

 

[Alex p h]

yes, but its not just that 1 part number you are thinking about is it , hence reference to other part numbers with zero's in
like
04G-05FSX90-046

Yeah I was just using as an example
In case of 04G-05FSX90-046 the only zeros in it that would be left off when someone has is inputted would be as 4g-5fsx90-046
And the ones eg 7500-450 would always be inputed in that fashion

 

[etaf]

i probably dont have a solution BUT
It would be necessary to know all the rules and then maybe using the Substitute() function it maybe be possible to look up the 3 columns again
I'm assuming people may enter
04G-05FSX90-046
OR they may enter
4G-5FSX90-046
what about
04G-5FSX90-046
4G-05FSX90-046

BUT nothing else - NOT just with out the first 0 only 4G-05FSX90-046, and NOT just removing the 2nd zero only 04G-5FSX90-046

Would a rule be to always remove the first zero , if the part has one - but then always remove just the 2nd zero if it follows a - dash
like
7351-0104 = 7351-104
7351-0204 = 7351-204
7351-0704 etc


probably going to need to start a new question , BUT only when you have all the possible combinations known

 

[Alex p h]

i probably dont have a solution BUT
It would be necessary to know all the rules and then maybe using the Substitute() function it maybe be possible to look up the 3 columns again
I'm assuming people may enter
04G-05FSX90-046
OR they may enter
4G-5FSX90-046
what about
04G-5FSX90-046
4G-05FSX90-046

BUT nothing else - NOT just with out the first 0 only 4G-05FSX90-046, and NOT just removing the 2nd zero only 04G-5FSX90-046

Would a rule be to always remove the first zero , if the part has one - but then always remove just the 2nd zero if it follows a - dash
like
7351-0104 = 7351-104
7351-0204 = 7351-204
7351-0704 etc


probably going to need to start a new question , BUT only when you have all the possible combinations known

Thank you soo much for your time

 

[etaf]

thats ok, let me know when you know all the rules - i can then have a look - but at the same time worth starting a new question , but only when you are clear on all the combinations