OT: Need an expert with VLookup in Excel

[Stolireef]

I have huge spreadsheet with some data that needs to be manipulated and I believe that VLookup would do the trick. That said, it's my weakest area of excel and I could use about 10 minutes of time from someone who is an expert.

Thanks in advance.

 

[kbarnett63]

What are you trying to do with it? I usually use VLookup for finding entries common on two different spreadsheets.

 

[Stolireef]

What are you trying to do with it? I usually use VLookup for finding entries common on two different spreadsheets.

Actually, all of the data is in one sheet. It's hard to do this without showing someone what I'm trying to do but basically, I have a spreadsheet that provides individual historical entries on a group of files in my office. Each row is comprised of a File number, Date Stamp and Time Stamp. So, basically, for John Smith's file, there would be several rows containing the forgoing information.

I have a list of new file numbers that I need to add as a new column and I have a translation table that allows me to determine which new file number goes to each entry. To make matters worse, some of the history entries do not have a new file number. Basically, I want to assign the new files numbers to the entries.

Thanks.

 

[Weyrman]

I think you will need to show it to someone in order to describe what you want to do.

 

[kbarnett63]

Actually, all of the data is in one sheet. It's hard to do this without showing someone what I'm trying to do but basically, I have a spreadsheet that provides individual historical entries on a group of files in my office. Each row is comprised of a File number, Date Stamp and Time Stamp. So, basically, for John Smith's file, there would be several rows containing the forgoing information.

I have a list of new file numbers that I need to add as a new column and I have a translation table that allows me to determine which new file number goes to each entry. To make matters worse, some of the history entries do not have a new file number. Basically, I want to assign the new files numbers to the entries.

Thanks.

VLookup will work for that. You have a PM with my cell number.

 

[Stolireef]

I just wanted to give a shout out to Weyerman and kbarnett63. They both responded quickly. What a great group of nerds. Thanks.