an alternative, if you wish to check both. In L4 i've created a DV list with 1 and 2 in the dropdown and in J6 the following formula dragged down.=CHOOSE($L$4,MIN(F6,D6),MAX(F6,D6)) now select 1 from the dropdown and you'll see the min, change to 2 and you'll see the max