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.

`VLOOKUP`

should do the trick; wrap it in an`IFERROR`

function to show blank when no match, as in:`IFERROR(VLOOKUP(<cell_reference_of_value_to_lookup>,<range_to_look_in>,<column_with_values_to_return>,FALSE),"")`

. The FALSE tells`VLOOKUP`

to only make an exact match. – chuff Jun 5 '13 at 17:11