There are two formuals I want to merge to make my worksheet to look more organized. Both formulas work as they should but I want to combine them into one cell. Thanks for any help
Formuals:
1. =IF(AND(C2=3,D2="0"),"Canceled Match","")
2. =IFERROR(INDEX($N$2:$P$4,C2,D2),"")
Hi Yuenk,
What I have understood by your requirement is that if C2=3 and D2=0, then it would say "Canceled Match" else you want to have the index to lookup the value as per given range (N2 to P4) according to C2 & D2, rows & col respectively.
In that case your formula will look like in E2
Formula:
Please Login or Register to view this content.
Hope this is what you were trying to have.
Thanks
Nisha Dhawan
If you like my answer please click on * Add Reputation
"If you can dream it, You can do it"
Could have sworn I tried it that way lol. Thanks though it works perfectly!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks