Vlookup Sum from a column

**Aread1990** · 09-08-2021, 07:31 AM

Hi Everyone!

I need to do a V-lookup to find someone's name but bring back each instance they show on another tab and the total value from a single column

The v-lookup i have done is currently =IFERROR(VLOOKUP(F7,'OBI SDSA Data'!B:E,4,FALSE),"0") - But how do i make this so it doesn't just bring back ONE value from the 4th column, but sums up each value from the 4th column when that persons name appears?

Hope this makes sense! and hope someone can help me!

**JohnTopley** · 09-08-2021, 07:47 AM

VLOOKUP is not the required function: from your description you need to use SUMIF(S).

See the yellow banner at top of the page on how to attach a sample workbook.

**Fluff13** · 09-08-2021, 07:50 AM

Hi & welcome to the board.
How about

Formula:

Please Login or Register  to view this content.

Vlookup Sum from a column

LinkBack

Thread Tools

Rate This Thread

Display

Vlookup Sum from a column

Re: PLEASE HELP - Vlookup Sum from a column

Re: PLEASE HELP - Vlookup Sum from a column

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Vlookup name in column 1 and text string in column 2 and bring that cell in column 2

[SOLVED] Macro to Insert column and include a VLOOKUP array for entire column

If vlookup value returned = 0 do a vlookup on an alternate column and return corresponding

having trouble sorting a date column in a sheet with a column populated via a vlookup

[SOLVED] Vlookup with column name instead of col_index_name(3rd Section of Vlookup formula)

[SOLVED] Copy data from column to other sheets, based upon vlookup/criteria on column a

Macro for Vlookup copy from one column to next one and change column reference

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions