Forum Discussion
Solved
Type in a sku in column a row 1 and have excel fill in multiple cells across the row
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. Here is ...
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.
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.