Screen shot 2012-08-08 at 5.16.06 PM.pngScreen shot 2012-08-08 at 5.15.13 PM.png
Here's my dilemma:
I am working off of two separate sheets in a workbook (see the screen shots). I want to write a formula that will put the "Table Host" Name found in sheet 2 (column c) in column G (sheet1) IF column "A" on sheet2 has a particular value.
The Values in sheet 2 column A range from 1-5. So, for example if there is a "1" in sheet 2 column A I want the Table host name "Keenan Miller" to appear in John Doe's Column G.
Not only this but I would like excel to find all the "1's" in column A and place their corresponding table host name in a separate blank cell for John Doe in column G and all the 2's in Column G for Jane Doe and so on...
Bookmarks