VLookup or another method?

[lee2121]

Hello,

I have an excel file with two sheets and i need to look up values from sheet 2 and display them in sheet 1 but a simple vlookup will not work as the values in sheet 2 can appear on more than one row and will then need to be added together. Also the data being read into sheet 1 will be displayed under 244 different columns depending on the column header value.

Sheet 1 column F and column G to IP contain the data for a vlookup or other method.
Sheet 2 column F contains the data for a vlookup match from sheet 1.
Sheet 2 column H contains the values which need to be added together where there is a match on more than one row and then displayed in sheet 1 in the correct column.

Please see attached file.

I'm really stuck with this one.

Appreciate any help, by the way I'm not an excel expert or programmer.

Thank you.

Sales Example.xlsx

[Estevaoba]

Hello.

Try in G2 and drag across and down:

Please Login or Register  to view this content.

Good luck!

[tanasedn]

Hi if i understand correctly:
In Sheet1 G2:

Please Login or Register  to view this content.

[FDibbins]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[lee2121]

Thank you very much, I did not think of SUMIFS. Your solution works brilliantly.

[tanasedn]

You are welcome!