Thread: Search and (VLookup)

Hi guys,

I have a spreadsheet where i have a column caller "Serial Number" (H1) which is full of serial numbers of mixed characters and lengths (EG: S09UJ10Y854297, 9RW3C95P). I am trying to make a function that will:

1) Allow me to input a serial number into a separate cell, which will then search the "Serial Number" column.
2) When it finds a match, it will then insert the serial number into a cell in the same row but different column.

So far I have =IF((VLOOKUP($Q$2,H:I,1,FALSE)),P2=H2)

Any help will be greatly appreciated.

Thanks

Say you are entering the serial number in Q2 and your column with serial numbers is column H.
If you want the vlookup match to appear in any cell in row 2 (which you then can copy down for Q3, Q4 etc)

=VLOOKUP(Q2,$H:$H,1,FALSE)

If I understood your needs correctly, this therefore would not require a macro or other complex solution.