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 an example:

               SKU                                    Product    Description                  Condition               

I enter:  12345678   Excel fills in:    Gadget      Gadget that gadgets      Recycled     

I enter:  23456789   Excel fills in:    Gizmo        Gizmo that gizmos        Brand New

I appreciate your input.  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.

Thank you in advance.

J

​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 an example:                SKU                                    Product    Description                  Condition               I enter:  12345678   Excel fills in:    Gadget      Gadget that gadgets      Recycled     I enter:  23456789   Excel fills in:    Gizmo        Gizmo that gizmos        Brand New I appreciate your input.  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. Thank you in advance. J  Read More

​