I have 2 workbooks I am working with.
- One workbook has an id and a category name.
- The other workbook shows a name and category section that has an id number (but not the actual description).
Basically I want to copy the full category text to my current workbook from the old one based on the id number into a new column
What kind of formula can I use to check the id number category pair and then copy it into the new workbook in a new column?
Any help is great!