Find Value Then Put Phrase in Adjacent Cell

[TStanwood]

Glossary Worksheet has "Taxonomy" and "Taxonomy Description."

CT Worksheet has "Taxonomy." I need to put the "Taxonomy Description" from Glossary worksheet in adjacent cell in the CT worksheet.

(Note: The CT Worksheet will eventually have 50,000+ lines. There can be hundreds of rows with the same taxonomy. I'm not sure if this makes a difference.)

Your help will be greatly appreciated.

Thanks, Todd

[daffodil11]

B2 =VLOOKUP(A2,Glossary!$A$2:$B$75000,2,0) and copy as far down as needed.

However, with 50k lines file size and processing may become an issue. Perhaps a VB alternative?

[AlKey]

Try this

Copy this formula and paste it in B2 on CT sheet and drag formula down.

=VLOOKUP(A2,Glossary!$A$2:$B$98,2,0)