Should I use VLOOKUP

Closed
Allen - Oct 16, 2011 at 09:15 PM
 Blocked Profile - Oct 17, 2011 at 01:39 AM
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
Oct 17, 2011 at 01:39 AM
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
0