Thread
:
If Function
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
MyVeryOwnSelf[_3_]
external usenet poster
Posts: 56
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.
Reply With Quote
MyVeryOwnSelf[_3_]
View Public Profile
Find all posts by MyVeryOwnSelf[_3_]