WHAT IS THE FORMULA FOR FINDING PARTIAL RANGE????
SOMEONE PLEASE HELP!
Answers
Answered by
5
Heya friend,
you need to enter it as an array formula, i.e. press Ctrl-Shift-Enter. It assumes that the substring you're searching for is in cell H1.
you need to enter it as an array formula, i.e. press Ctrl-Shift-Enter. It assumes that the substring you're searching for is in cell H1.
vikaash50:
=VLOOKUP($K$1&"*",$E$1:$H$14,4,FALSE), pressEnterkey to get to value
I wanted to know the formula for calculating partial range!
Answered by
0
=VLOOKUP($K$1&"*",$E$1:$H$14,4,FALSE), press Enter key to get to value.
what is the formula for partial range?
Similar questions