New to excel formulas (I have 2003) and this forum but here is my question:
I have a formula below
=VLOOKUP(C2,Importance,2,FALSE) + VLOOKUP(D2,Effort,2,FALSE) +VLOOKUP(E2,Urgency,2,FALSE)
This formula just returns a number BUT I wish to add to his formula to look at another cell in the same sheet and If the cell has just a "c" in it, then I would like to formula to return the number 999 versus the normal numbers according to the lookup table.
thanks for your help.
No way to test this myself, but you can give it a try, just wrapped your whole formula in an IF statement:
=IF(B2="c",999,VLOOKUP(C2,Importance,2,FALSE) + VLOOKUP(D2,Effort,2,FALSE) +VLOOKUP(E2,Urgency,2,FALSE))
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
JB,
It worked! thanks man.
Mark
Glad to help.
If that takes care of your need, be sure to EDIT your original post (Go Advanced) and mark the PREFIX box [SOLVED]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks