Hi, Dave:
Thanks. You know, I tried this--used the lookup wizard--and I'm not getting what I'd hoped for (I should bow out and head to the newusers section, I'm sure) I want to have columns A and B (as what a layperson might call a "set") with C, which has the e-mail addresses. Now, I have my existing example below, but I want to "match" my short roster in columns A and B with the unexpurgated list of all emails in columnC. My short roster has fewer "smiths" than all smiths who have email here. Is there a way I can do this --and write a formula to do it? Thanks!
Name Number All Pop emails
Smith A 112 (e-mail address removed)
Smith F 117 (e-mail address removed)
Smith J 119 (e-mail address removed)
Smith K 120 (e-mail address removed)
Smith L 123 (e-mail address removed)
Smith M 125 (e-mail address removed)
----- Dave Ramage wrote: -----
Take a look at the VLOOKUP worksheet function.
Cheers,
Dave
-----Original Message-----
I have a worksheet with email addresses in a column and a
LASTNAME column in one datasheet. I want to match those
two columns to another datasheet that has LASTNAME and a
lot of other columns with data. Trouble is to this new
user, that the columns in the first worksheet have more
rows/data than the second data sheet. So, in my mind I
see one column as a list, I compare that list of names to
the second list, and about ten down the list, there's
a 'new' name. So the second sheet's list is different,
but I want to pull the info from the first worksheet and
make it ''find' its correct mate in the second. please
help? sorry such a simple question--my training is in
literature, but I have moved into administration. . .
