Hi,
I was hoping someone can help me with a excel return query. I have three sheets, I want to check if a value is seen in column B, in this case Medlay, and if it is found return a series of values instead, e.g. Skill 1, Skill 2, Skill 3 and then the date in sheet 3
Sheet 1
Person Skill Date
James Skill 01/12/2012
Dave Medlay 02/12/2012
Eric Medlay 03/12/2012
Frank Skill 04/12/2012
Sheet 3
person Skill Date
Dave Skill 1 02/12/2012
Dave Skill 2 02/12/2012
Dave Skill 3 02/12/2012
Eric Skill 1 03/12/2012
Eric Skill 2 03/12/2012
Eric Skill 3 03/12/2012
Any help would be great!
Thanks
James
Bookmarks