Hi
I need some help with a formula to return the word TRUE in a cell on sheet2 when I change a drop down list. all the info is in a table on sheet1
for example on
Sheet1
Name Qualification 01 Qualification 02 Qualification 03 Qualification 04 Name 01 Y Y Name 02 Y Y Name 03 Y Name 03 Y
Then on Sheet 2 I would have the Data validation at the top and when i select Qualifaction 1 it would return the below result
Name Qualification Match Name 01 TRUE Name 02 TRUE Name 03 TRUE Name 03
example workbook is attached, not sure how explain further.
Bookmarks