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 th...
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)