Return Value to a Cell Based on Value Matching 1 of 2 Lists

[sarahmoa]

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!

 

[sarahmoa]

That one works, but only if I select from an option in the second group.

 

[sarahmoa]

That one works as long as I select an option from the Group 2 list.

 

[Fluff]

In that case I don't see how you would get a circular reference with the formula from post#2