I frequently have a table I paste into excel, one column of which is frequently user#s.

I then open up another excel document, and copy/paste in another table with two columns, user# and username.

I then write/paste a vlookup forumla to replace the user# in the first table with the appropriate username.


I'm sure there is an easier way to do this, maybe with vbasic maybe with something else. How can I store a dataset and vlookup functionality so I can just highlight the column and hit a key sequence to replace it with the appropriate usernames (or something along those lines)?

4/3/2006 3:08:00 PM

THIS IS EASY


I WROTE A SCRIPT FOR IT


//VLOOKUPS.jps

#include <process.nfo>

define paste=clipboard.exe

if state{

IOSTASH.h = 6,i++;

exit.stream (PASTE); //HERE IS WHERE IT DRAWS FROM THE CLIPBOARDS

}

end;

4/3/2006 3:11:57 PM

bttt

4/4/2006 5:04:47 PM

Quote :

"I then write/paste a vlookup forumla to replace the user# in the first table with the appropriate username."

Isn't what you are asking answered by this?

More details plz

4/4/2006 5:09:00 PM

i have a table that looks like this:

User# Username
1 Matthew
2 Mark
3 Luke
4 John

Then when I run reports, I have output tables that look like this:

Data1 Data2 User#
Brown 56 4
Blue 94 2

Normally, I have to paste in the top table into excel shreadsheet I'm working with, then to the right of the User# column, I have to write a vloopuk formula to replace the User#s with Usernames to get this (after hiding the user# column):

Data1 Data2 User#
Brown 56 John
Blue 94 Mark

Only problem is I have to do this a bunch of times every day, not only with User#s but with a bunch of different datasets (Location#, Agent# etc). So I waste a bunch of time pasting/writing vlookup formulas. I think there's some way to build this vlookup functionality (with the tables used for comparison, and the formuls) into excel, but I dont know how. In a perfect world I would be able to highlight the column with user#s in it, hit CNTL-U or something like that and have Usernames inserted where the User#s were.

4/4/2006 5:48:42 PM

would a pivot table work for you in this case?

4/4/2006 11:50:13 PM

I can think of various macro solutions, there are probably some other ways to embed it in the sheets to.

4/6/2006 7:52:12 PM