vlookup with multiple lines of same value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to do a vlookup on a cell range that has multiple lines with the
same lookup value. I need to get a total value returned for the lookup value.
Example:

ITEM QTY

AABBCC 5
JKJH 3
YTRE 2
YTRE 3
YTRE 1
MHJN 2
MHJN 2

I would like to be able to do a vlookup from one worksheet with the value
YTRE and get the value of 6.

Thanks in advance for your help.
 
Hi

Something like
=SUMIF(Sheet1!A2:A100,"YTRE",Sheet1!B2:B100)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
Vlookup and retrieve values 1 row below the normally retrieved val 2
Returning Multiple Results with Vlookup 1
Is there a way to parse multiple values in a cell and applycalculations to those cell ? 1
Returning Multiple values from A Vlookup 3
Vlookup array formula problem 2
VLOOKUP source values are a formula result. Getting #N/A 7
Using Value of a Cell in the Range Reference in VLOOKUP 1

Back
Top