Hello,
I am working furiously on a tracker for my job, but I am relatively new to the Excel formulas and am having some trouble. I am almost finished, but there is one final touch that I am trying to do, if possible. In the image below, I am on Sheet 2. Columns J-L have a data selection of --, Yes, or No. Column B will have an individual's name. I am trying to see if it is possible so that when No is chosen (data source cell C103) in any of the cells in Columns J-L, the individual's name from that row will show up on Sheet 1's B13, B14, B15, etc. Is this possible??
Ex. Sheet 2, Row 4, Column B reads John Doe. J4 reads NO, but K4-M4 read YES.
Because J4 reads NO, John Doe's name shows on Sheet 1 B13.
Is it possible?
Spreadsheet sample.bmp
Bookmarks