Superstig666
New Member
- Joined
- Oct 28, 2014
- Messages
- 9
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?
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?