# VLOOKUP help

Hello,

I am having trouble figuring out how to concatenate the text in columns 8 and 9 within my VLOOKUP formula.
=VLOOKUP(SpeciesRef,Species_Data,8,FALSE)

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

###### Who is Participating?

Microsoft MVP ExcelCommented:
Hello,

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?

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

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

cheers, teylyn
0

Commented:
You can use & to combine them:
=VLOOKUP(SpeciesRef & Species_Data,8,FALSE)
0

Author 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.
0

Author Commented:
Thanks Teylyn that is EXACTLY what I was after. Stupid me was simply putting:
=VLOOKUP(SpeciesRef,Species_Data,8,FALSE)&(SpeciesRef,Species_Data,9,FALSE)

I have just learnt something new! thank you so much!
0

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)
0

Author Commented:
Yeah thats ok, excel corrected it for me :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.