I want to fill multiple cells based on the result in one cell

Hi,

Welcome to the Forum.

Can you upload a workbook with sample data?

Kindly do not upload a picture of your file... Rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome (manually entered is ok) and how you arrived at that. (Exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you. Also, not all members can upload picture files (Company firewalls, etc.)

To attach a file to your post, click advanced (next to quick post), scroll down until you see "manage file", click that and select "add files" (top right corner).
Click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window. You can then close the window to return to the new post screen.

Essentially, what I'm trying to accomplish is a purchase history. There will be a very limited number of different UPCs and the same items will be purchased many times. Having a second sheet as a data source would not be a problem.

I will not be tracking amounts on hand or when things leave, this is not to serve as an inventory, otherwise I would imagine that sort of software already exists.

Example spreadsheet attached. Random household products added for illustration.

Does using VLOOKUP for each Product, Maker and Contents fulfill your need?

In Sheet1, For Product, use

Formula:

Please Login or Register  to view this content.

For Maker, use

Formula:

Please Login or Register  to view this content.

For Contents, use

Formula:

Please Login or Register  to view this content.

Try this......
On sheet1,
In B2

Please Login or Register  to view this content.

and then drag across to D2 and down until you get blank cells.

Originally Posted by crashwg

So do I add rep to multiple people who solve the same problem?

There is no hard and fast rule for adding reps here in this forum.. Its just a way of showing your appreciation to those who are posting solutions...

Look at the formula suggested in the post#5 like this......

When you place the formula in B2, IFERROR(INDEX(Sheet2!B$2:B$4,MATCH($A2,Sheet2!$A$2:$A$4,0)),"") returns the matching value from the col. B of sheet2 and while you drag the same formula across to C2 the same formula becomes IFERROR(INDEX(Sheet2!C$2:C$4,MATCH($A2,Sheet2!$A$2:$A$4,0)),""), it returns the matching value from col. C of sheet2 and while you further drag that formula to D2, the formula becomes IFERROR(INDEX(Sheet2!D$2:D$4,MATCH($A2,Sheet2!$A$2:$A$4,0)),"") and thus returns the matching value from col. D of sheet2. Note that the Match portion of the formula remains the same whether you drag the formula across or down since it is using the absolute cell reference. But in the Index portion of the formula [INDEX(Sheet2!B$2:B$4,], the row reference is locked but it is using the relative column reference. So when you drag the formula from B2 to C2, the Index portion changes to [INDEX(Sheet2!C$2:C$4] and so on.
Therefore only one formula can return the matching values from all the three columns. B, C and D of sheet2.
I hope that this will help you to implement the formula in your original workbook. The thumb rule for this formula to work is, all the target columns of sheet2 should be adjacent to each other. (Like Col. B, C and D). And if you are trying to return first value from say col. B and second value from col. D and third value from col. F, this formula will not work because the Col. B, D and F are not adjacent to each other.