I am trying to match the data from one table to another.
The primary table has two columns (an alpha item description in column A and a numeric value for that item in column B) in an unsorted order. The primary table must remain in this format, I can't sort them.
The secondary table of data I am trying to match also has two columns (an alpha item description in column A and a numeric item value in column B) in an unsorted order, is not sorted the same way and is missing some of the rows of the primary table.
I would like the primary table to search the secondary table for a matching item description and copy that items numerical value.
If the secondary table does not have that item I would like to leave that cell blank.
Is there an excel formula to resolve this issue. Since I am new to this formula I can't post an example. Thanks for the help.