Type in a sku in column a row 1 and have excel fill in multiple cells across the row

Question

Hi,I would like to be able to type in a sku (I have a database already created, just need to know how to implement it) and have excel fill in multiple cells across a row in each column.&nbsp; Here is an example:&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SKU&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Product&nbsp; &nbsp; Description&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Condition&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;I enter:&nbsp; 12345678&nbsp; &nbsp;Excel fills in:&nbsp; &nbsp; Gadget&nbsp; &nbsp; &nbsp; Gadget that gadgets&nbsp; &nbsp; &nbsp; Recycled&nbsp; &nbsp; &nbsp;I enter:&nbsp; 23456789&nbsp; &nbsp;Excel fills in:&nbsp; &nbsp; Gizmo&nbsp; &nbsp; &nbsp; &nbsp; Gizmo that gizmos&nbsp; &nbsp; &nbsp; &nbsp; Brand New&nbsp;I appreciate your input.&nbsp; I tried reading up on this and watching the videos but they weren't for this type of VLOOKUP ... it was for typing in multiple criteria in multiple cells and I just want to type in the sku and have it fill in the rest of the data.&nbsp;Thank you in advance.&nbsp;J

hansvogelaar · Accepted Answer

johnsboxftm&nbsp;
Let's say your database looks like this, on a sheet named Product List.

On another sheet, you enter a SKU in A2 and down.
In B2:
=XLOOKUP(A2, 'Product List'!$A$2:$A$1000, 'Product List'!$B$2:$D$1000, "")
Fill down.

Forum Discussion

Type in a sku in column a row 1 and have excel fill in multiple cells across the row

Share

Resources