Excel 2007 : 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

Please have a look at the attached.

I've used a dynamic range to drive a (yellow) drop down list and an event driven macro to add the copies to the other column.

You will find the code on the sheet1 stab in the VBA editor (Alt F11).

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)

Please Login or Register  to view this content.

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