Forum Discussion

cTennant2's avatar
cTennant2
Copper Contributor
Sep 13, 2024

How to return the next value in a row based on whether it is already used in a list

Hi I have 2 sheets as below, In sheet 1, when a user selects 'RED' in ID type, they will be prompted to enter 'original ID number'.   I then need it to check the 'original id number' against the 'ID ...

Resources