Should I use VLOOKUP

Closed
Allen - 16 Oct 2011 à 21:15
 Blocked Profile - 17 Oct 2011 à 01:39
Hello,

I have an excel sheet (sheet 1) with valves in columns A and B that I need to look up in another sheet (sheet 2). Once these valves a located in sheet 2 (columns A and B) I need it to read another column (column D), problem I have is that there are multiples of sheet 1 column A and B valves in sheet 2. Example below:

Sheet 1
Column A Column B Column C
3.1.01 1.06 =
3.1.01 1.08 =

Sheet 2
Column A Column B Column D
3.1.01 1.06 10
3.1.01 1.06 45.89
3.1.01 1.08 5.68
3.1.01 1.08 2.42

Can anyone suggest a forumla i can use that will add up the two or more valves in Column D?


1 response

Blocked Profile
17 Oct 2011 à 01:39
Greetings,

Please, bare in mind that before any answer given on the forum, you should know that there are volunteers who give their time trying to solve user problems. They do have a life other than this forum including me.

Therefore, it is specifically requested from Kioskea forum users to show their respect. For this, the use of polite expressions is a minimum.
https://ccm.net/apps-sites/internet-archeology/ccm/10131-terms-of-use-for-ccm-respect-for-others/#politesse

To say please, thank you, appreciate, grateful, etc... is common courtesy when you want something, especially help!

You must copy, modify and repost your message respecting the politeness charter.

We trust that you understand.

Moderator