I've never used the Lookup function before and I need some help setting this up (I'm assuming that I will be using Lookup).
Worksheet 1, Column A will contain a complete list of approx. 100 commercial titles. Column B will have the corresponding categories for each commercial title.
In Worksheet 2. Column A will be a random list of the commercial titles (all of which are already entered in Worksheet 1, Column A). Rather than manually typing the categories in Column B, I would like to use the lookup function to have these categories entered automatically by referencing the titles and categories in worksheet 1.
When the commercial title in Worksheet 2, Column A matches the commercial title in Worksheet 1, Column A, I would like the category that appears in Worksheet 1, Column B to be automatically entered in Worksheet 2, Column B.
Any suggestions? Thanks.
Worksheet 1, Column A will contain a complete list of approx. 100 commercial titles. Column B will have the corresponding categories for each commercial title.
In Worksheet 2. Column A will be a random list of the commercial titles (all of which are already entered in Worksheet 1, Column A). Rather than manually typing the categories in Column B, I would like to use the lookup function to have these categories entered automatically by referencing the titles and categories in worksheet 1.
When the commercial title in Worksheet 2, Column A matches the commercial title in Worksheet 1, Column A, I would like the category that appears in Worksheet 1, Column B to be automatically entered in Worksheet 2, Column B.
Any suggestions? Thanks.