I have a worksheet for electronic parts. Each part has various Part numbers dependent on the supplier. The part number is shown in one column with alternative part numbers in the next 2 columns. I want to be able to enter one of the part numbers and have is find the alternative numbers and the provide my internal part number. I have tried using VLookup, but it only allows the lookup to work on one column. I need to have it look at all three columns and the give me our internal corresponding part number. Any ideas? I could not get XLookup to work either.