Thread: find a value based on two conditions in a table
View Single Post
 
Old 06-02-2022, 10:09 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
  
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
try in C2:
=INDEX($F$3:$L$6,MATCH($A2,$E$3:$E$6,0),MATCH($B2, $F$2:$L$2,0))
copy down.
Reply With Quote