I have a column P: which either has a number in it or it doenst. If it does have a number in it, I want to paste that number(s) into another table on the same sheet, in column Z, next to the people that were resonsible for having that problem job.
For example, if Joey and Steve are on a job that has a problem and the number for that job was 45789. I want "45789" to be posted in Joey's cell in the Z column, and "45789" posted in Steve's cell in column Z. I need this done for every job that has a problem number associated with it. As you can see, sometimes each employee is on a job by them self, that is why their name is is colum Q and R at the same time. If they are by them self and have a problem job, I want that number posted by their name in column Z only once.
I cannot figure this out, Ive tried index, vlookup, and a bunch of other stuff. I have excel 2010, if you need anything else let me know.
I dont nescessarily need commas between each problem job number in column Z next to each persons name, but if I could have some way of differientating each problem job number with somthing, even if its a return, that would be awesome.
Thank you, and have a great day
Bookmarks