Thread: If Function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MyVeryOwnSelf[_3_] MyVeryOwnSelf[_3_] is offline
external usenet poster
 
Posts: 56
Default If Function

I am trying to use if function however Nested If is limited to 7. How
do I over come this.


One way is to avoid using IF and instead use something like this:
=INDEX($AA$2:$AA$11,MATCH($U3,$AB$2:$AB$11,1))

Hope this helps getting started.