lostinexcel

Posts: n/a

vlookup with multiple lines of same value

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
vlookup over multiple worksheets	Neil	Excel Worksheet Functions	3	December 16th 04 08:19 PM
Can vlookup return multiple matches in a single cell?	cchristensen	Excel Discussion (Misc queries)	3	December 2nd 04 01:56 AM
VLOOKUP not working	Scott	Excel Worksheet Functions	3	November 12th 04 08:06 PM
Multiple Vlookup?	changeable	Excel Worksheet Functions	0	November 9th 04 11:52 AM
multiple vlookup	choice	Excel Worksheet Functions	2	November 1st 04 06:55 PM

All times are GMT +1. The time now is 06:35 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us