Amending value in Vlookup

Copper Contributor

Hi Guys,

 

What I need to be able to do is amend the T3 number after is has been found, but still use the same vlookup. Say T3 is the "home" team and S3 is "away", I want to add extra to T3 after it has been found in the table array - say S3 is 101 and T3 is 99 in the table array, i want to at 3 points to T3 after it has been found.

=IF(OR($S3="",$T3=""),"",IF(VLOOKUP($S3,$A$3:$N$32,14,FALSE)>VLOOKUP($T3,$A$3:$N$32,14,FALSE),$S3,$T3))

 

Is this possible? 

0 Replies