Combine 2 VLOOKUPs to give results in same cell

**Jamieandjo** · 09-01-2020, 11:19 AM

Hi everyone

Are you able to help, im using a vlookup to return text in a coloumn on a different tab if there is a match based on a cell in my main working tab.

This currently looks at my August tab but I would also like it to return any text from a previous month too i.e a July tab

My curren formula here works for one return

=VLOOKUP('Current Extract'!F6, 'August 2020'!F:V,16,FALSE)

But I need something like this, can someone help how to merge 2 VLOOKUPs as I'm getting an error 😢

=VLOOKUP('Current Extract'!F6, 'August 2020'!F:V,16,FALSE)&VLOOKUP('Current Extract'!F6, 'July 2020'!F:V,16,FALSE)

Any ideas?

**AliGW** · 09-01-2020, 11:37 AM

Administrative Note:

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

**ChemistB** · 09-01-2020, 11:39 AM

Waiting on OP to make Mod Changes

**PeteABC123** · 09-01-2020, 11:39 AM

Hi Jamieandjo:
It might be that your selected table range is 17 columns, and you want to bring in the result in the 16th column. Is 16 or 17 the desired column? Might be hosing your result.

Pete

**Jamieandjo** · 09-01-2020, 12:27 PM

ht tps:/ /ww w. mrexcel.c om/board/t hread s/combine-2- vlo okups-to-give-returns-in-same-ce ll.114 4551/

**Jamieandjo** · 09-01-2020, 01:03 PM

Originally Posted by PeteABC123

Hi Jamieandjo:
It might be that your selected table range is 17 columns, and you want to bring in the result in the 16th column. Is 16 or 17 the desired column? Might be hosing your result.

Pete

Hi Pete, the return data is always in coloumn 17 of the the tabs. So what I need is it to took at the two tabs and return the commentary from both if there is a bit on the first reference 👍

**Sam Capricci** · 09-01-2020, 01:10 PM

Hi Pete, the return data is always in coloumn 17 of the the tabs. So what I need is it to took at the two tabs and return the commentary from both if there is a bit on the first reference

but the range you list in your formulas is only going over 16 columns - to column U.
VLOOKUP('Current Extract'!F6, 'August 2020'!F:V,16,FALSE)

**Jamieandjo** · 09-01-2020, 01:32 PM

Originally Posted by Sam Capricci

but the range you list in your formulas is only going over 16 columns - to column U.
VLOOKUP('Current Extract'!F6, 'August 2020'!F:V,16,FALSE)

Sorry I meant 16!!!

**Sam Capricci** · 09-01-2020, 01:42 PM

it works fine for me, can you post a small sample workbook with expected results?
I changed tab names to match yours and it worked fine for me.
=VLOOKUP('current extract'!F6,'August 2020'!F:V,16,FALSE)&VLOOKUP('current extract'!F6,'July 2020'!F:V,16,FALSE)

**Sam Capricci** · 09-01-2020, 01:43 PM

of course it does depend on what you are looking to pull. Also if you are only going over 16 columns then you just need this...
=VLOOKUP('current extract'!F6,'August 2020'!F:U,16,FALSE)&VLOOKUP('current extract'!F6,'July 2020'!F:U,16,FALSE)

**Sam Capricci** · 09-01-2020, 02:11 PM

you know, posting a simple workbook with as few as three examples, one you are looking up in current extract, one in Aug 2020 with "matching value" in col F and the value to return in col U, same in July 2020 tab and showing the error you are getting would go a long way to helping us figure out what is going on.

**ChemistB** · 09-01-2020, 03:32 PM

My guess is you need to wrap your two VLOOKUPs in IFERROR like so and maybe add a TRIM

Formula:

Please Login or Register  to view this content.

If that doesn't work, perhaps upload an example workbook

Combine 2 VLOOKUPs to give results in same cell

LinkBack

Thread Tools

Rate This Thread

Display

Combine 2 VLOOKUPs to give results in same cell

Re: Combine 2 VLOOKUPs to give results in same cell

Re: Combine 2 VLOOKUPs to give results in same cell

Re: Combine 2 VLOOKUPs to give results in same cell

Re: Combine 2 VLOOKUPs to give results in same cell

Re: Combine 2 VLOOKUPs to give results in same cell

Re: Combine 2 VLOOKUPs to give results in same cell

Re: Combine 2 VLOOKUPs to give results in same cell

Re: Combine 2 VLOOKUPs to give results in same cell

Re: Combine 2 VLOOKUPs to give results in same cell

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Combine two Vlookups

[SOLVED] Formula in Cell causing my comparitor code to give false results

formula to combine like cell and results

Combine sheets using vlookups and pivots?

[SOLVED] Multiple Vlookups & Join results in one cell

Possible to combine multiple VLOOKUPs?

Match one cell for another AND give results

Bookmarks

Bookmarks

Posting Permissions