Vlookup

**tjamison** · 06-24-2010, 10:43 AM

In sheet 1 column A I have about 5000 I.D. numbers which are out of order and not sorted. They are not in ascending order because they are the specific I.D. numbers for various firms and organizations. In sheet 1 column B I have the organization name next to its I.D. number.

Now, in sheet 2 column A, I have the same list of I.D. numbers (about 5000 or so) but they are in a different order than in sheet 1 column A. My objective is to populate sheet 2 column B with the organization names that correspond to each I.D. number. I tried to use VLOOKUP with False in the range category but got #NA's in all of the cells.

I would appreciate any answers, suggestions, or advice.

**sweep** · 06-24-2010, 10:48 AM

=INDEX(Sheet1!B:B,MATCH(Sheet2!A1,Sheet1!A:A,0))

This assumes that your data starts in A1 on both sheets.

**tjamison** · 06-24-2010, 12:43 PM

Thanks! One more question. When I try to copy and paste the newly populated data into a new excel sheet, #REF! appears in each cell. Is their any way I can copy/paste this data into new excel sheets and only take the name without the formula? Thanks