Dynamic finding and replacing via functions

D

dand06

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 [email protected] (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 [email protected] jsmith (was
blank, now user defined)

Any ideas?
thanks!
Dan
 
D

dand06

That's a great little sub! Exactly what I was looking for! If anyon
else can think how to do this via an integrated function (so peopl
don't freak out about giving this sheet Macro permissions), I'd be mos
appreciative!

But thanks a ton Max!
Da
 
M

Max

You're welcome, Dan !
Thanks for feedback ..
.. how to do this via an integrated function
Click to expand...
Just some thoughts (but do hang around for insights from others) .. Formulas
eg: an INDEX/MATCH placed within the AIM col can only return/populate one B4
value into 1 correct cell in the AIM col at any one time. It cannot then
"freeze" the value there. So when B4 is re-input by the next user (with a
different email in B3), the AIM col formulas will recalc and return the B4
value into another cell correctly, but we would lose the B4 value returned
for the earlier user.
 
Top