So cols b & c map a course id to a course name.

How bout this in d1 then copy down:

vlookup(A1,$B:$D,2.false)

(thats an unusual set of data)

"Cindi S" wrote in message
...
I've been sent an Excel spreadsheet with several columns of data one of
which contains the course numbers but what I really needed was the
course ID in order to import this data into an Access table.

Since I have an Access table with course numbers and their matching
course ID, I exported those two fields of data into an Excel spreadsheet
and then copied and pasted them into the original spreadsheet so it
looks like this:

Col A Col B Col C Col D
ACCT1220 TEC1110 3
PHS2200 ACCT1220 1
TEC1110 PHS220 2

So Col C contains the matching ID to Col B. What I need is the matching
ID to Col A placed in Col D like this:

Col A Col B Col C Col D
ACCT1220 TEC1110 3 1
PHS2200 ACCT1220 1 2
TEC1110 PHS220 2 3

At this point I would probably delete columns A-C because I would have
the correct ID associate with the remaining columns (E-H) of data.

I have not used Excel in years. In looking at the formula you provided
is it possible to put a range in place of b1 to cover the entire column?

Thank you,

Cindi

*** Sent via Developersdex http://www.developersdex.com ***