Stormy4757
New member
- Joined
- Dec 26, 2013
- Messages
- 11
- Reaction score
- 0
- Points
- 0
I need a vlookup formula or whatever formula to do the following to the attached spreadsheet
The first worksheet is the sheet I want to pull information into. I want to search the2nd worksheet, User Profile, in the PID column, for each of the PIDs in the first worksheet (column B). I then want to pull that whole line of information into the Columns C through X. I have ensured that the first two will have results. Not all PIDs will be found.
I hope I am making sense. My manager tells me she wants this for her 3 o’clock meeting tomorrow (Wednesday). I am not a happy camper cause this has 50,000 some lines of data. Can any one please help me?
View attachment Test File.xlsx
The first worksheet is the sheet I want to pull information into. I want to search the2nd worksheet, User Profile, in the PID column, for each of the PIDs in the first worksheet (column B). I then want to pull that whole line of information into the Columns C through X. I have ensured that the first two will have results. Not all PIDs will be found.
I hope I am making sense. My manager tells me she wants this for her 3 o’clock meeting tomorrow (Wednesday). I am not a happy camper cause this has 50,000 some lines of data. Can any one please help me?
View attachment Test File.xlsx