I am having trouble figuring out how to concatenate the text in columns 8 and 9 within my VLOOKUP formula.

SpeciesRef and Species_Data are named ranges and I was hoping to combine column 8s value with column 9.

Can someone please help??
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

You can use & to combine them:
=VLOOKUP(SpeciesRef & Species_Data,8,FALSE)
vegas86Author Commented:
No sorry, I mean that there are named ranges within the formula, the formula is looking up the species reference within the species data. Column 8 and 9 are within 'species data'

for exmaple my species ref may be pup_100 so the forumla is looking for 'pup_100' within my named range of species_data and then returning the data in columns 1,2,3 so forth.
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:

a sample workbook with your data layout would certainly be helpful. Do you want to combine the search term? Or the lookup columns? Or both?

Please post some sample data.

Without seeing that, I'm guessing that you may want

=VLOOKUP(SpeciesRef,Species_Data,8,FALSE)&" - "&=VLOOKUP(SpeciesRef,Species_Data,9,FALSE)

cheers, teylyn

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Amazon Web Services

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

vegas86Author Commented:
Thanks Teylyn that is EXACTLY what I was after. Stupid me was simply putting:

I have just learnt something new! thank you so much!
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Just realised that the above formula contains one = sign too many. Please correct to

=VLOOKUP(SpeciesRef,Species_Data,8,FALSE)&" - "&VLOOKUP(SpeciesRef,Species_Data,9,FALSE)
vegas86Author Commented:
Yeah thats ok, excel corrected it for me :)
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.