Hello all,
So, I have an array of data, specifically columns of lastname, firstname, and emailaddress. I have the user enter their last name into a validation cell and the two cells below ("first name" and "email address") are populated with a VLOOKUP function. All very simple. (see below)

Type Last Name: Smith (user enters last name here; list validation used)
First name John E. (VLOOKUP populates)
Email address jsmith@nowhere.com (VLOOKUP populates)

Now, I've added a new column: IMname

What I'd like, is for the user to be able to specify their IM name in a cell, and use a function (or macro if I *must*) to locate the IMname cell that corralates to their row and replace the value with the user's input.

Enter IM name
AIM: jsmith (user enters value here)


<further down in the data array>

LastName FirstName Emailaddress AIM
Smith John jsmith@nowhere.com jsmith (was blank, now user defined)

Any ideas?
thanks!
Dan