Forum Discussion
Auto Filling a row with one piece of data from another sheet
I am trying to simplify the steps in auto populating the rows in an invoice tracker. What I would like is when someone types in a serial number, the rest of the row will automatically fill in with the year purchased, model number, and location. I have 4 sheets that I need to pull data from ( I can also make a master list if that works better, they are just currently split by location).
there are over 120 different serial numbers.
2 Replies
In my example i created a worksheet named "Master list" and i aligned columns according to worksheet "Invoice Tracker". Please see attached file. Then you can enter formula below in cell B2 and fill it in across range B2:E1000 (for example).
=VLOOKUP($A2,'Master list'!$A$3:$E$120,COLUMN('Invoice Tracker'!B1),FALSE)
