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.

Can someone please help??
vegas86Asked:
Who is Participating?
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)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?

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
0
 
jimyXCommented:
You can use & to combine them:
=VLOOKUP(SpeciesRef & Species_Data,8,FALSE)
0
 
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.
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

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

All Courses

From novice to tech pro — start learning today.