Is it possible to find more than one vlookup result and tota

amwpitt · May 13th, 2002, 01:50 PM

I am working on an inventory workbook and need to be able to find all results of a vlookup rather than just the first one and then total them to return to the sheet. I have one sheet to keep the running inventory total, one for items received, and one for items shipped. VLOOKUP is working fine except it only returns the first occurrence and I would like it to total all occurrences and return them to the inventory sheet.
If this is a basic question I am sorry, but I searched and could not find an answer.
Thank you for any help,
Adam

Aladin Akyurek · May 13th, 2002, 01:53 PM

Quote:

On 2002-05-13 12:50, amwpitt wrote:
I am working on an inventory workbook and need to be able to find all results of a vlookup rather than just the first one and then total them to return to the sheet. I have one sheet to keep the running inventory total, one for items received, and one for items shipped. VLOOKUP is working fine except it only returns the first occurrence and I would like it to total all occurrences and return them to the inventory sheet.
If this is a basic question I am sorry, but I searched and could not find an answer.
Thank you for any help,
Adam

Consider using SUMIF instead.

amwpitt · May 13th, 2002, 02:17 PM

Thank you, this was much easier than I expected.

Adam

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 13th, 2002, 01:50 PM	#1
amwpitt New Member Join Date: May 2002 Posts: 2	I am working on an inventory workbook and need to be able to find all results of a vlookup rather than just the first one and then total them to return to the sheet. I have one sheet to keep the running inventory total, one for items received, and one for items shipped. VLOOKUP is working fine except it only returns the first occurrence and I would like it to total all occurrences and return them to the inventory sheet. If this is a basic question I am sorry, but I searched and could not find an answer. Thank you for any help, Adam

May 13th, 2002, 02:17 PM	#3
amwpitt New Member Join Date: May 2002 Posts: 2	Thank you, this was much easier than I expected. Adam