Dear All

Please see enclosed and kindly help.

I have 2 excel tabs, one is the inventory record and the other is a empty table with all the heading.

I need to key in the serial number under the "serial number columns and then the rest will appear. Can someone please help, the function is some like Vlookup.....

Thank you


Regards,
Richard Tan

Richard

Please find attached ZIP

Hope this helps.
Regards, Matt

Richard

Please find attached ZIP

Hope this helps.
Regards, Matt

Yes, it is very helpful on this example but when I copy it on the actual spreadsheet, it doesn;t work. Please see enclosed real data on spreadsheet.

Hope someone can help me.

Thank you




Regards

See if this helps. Enter the serial number data on the "Serial Entry" sheet.