Hi guys,
I have the following formula in cell S2.
I need to run the formula above if the value in R2 starts with a letter, and the formula below if it starts with a number:
Please Login or Register to view this content.
But I need it all to be in one long formula.Please Login or Register to view this content.
Many thanks,
Luke
=if(ISNUMBER(--LEFT(R2)),IFERROR(VLOOKUP(R2,leveltopoints,2,0),""),IFERROR(VLOOKUP(R2,gradetopoints,2,0),""))
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks