My brain is spinning at the moment with my issue. I have a spreadsheet where column V uses Data Validation to pull from a list found in a separate tab for Data. The items in the dropdown are categorized in two groups - Group 1 is on the Data tab in A2:A19 while Group 2 is A21:A47. Based on which value is selected in column V, I need it to return Group 1 or Group 2 to column U). I can get halfway there with =IF(COUNTIF(Data!A2:A19,V3),"1","") but I don't know how to make it also return "2" for the second group list if something is chosen from that list instead.
Any help is greatly appreciated!
Any help is greatly appreciated!