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