View Single Post
  #2   Report Post  
Duke Carey
 
Posts: n/a
Default Alternative to multiple IF limits

You can easily use the MATCH() function to figure out which column and which
row to use. Those two values would be arguments to the INDEX() function