hello guys
=OFFSET(INDEX('Bonus Calculator'!G9:G21,MATCH('DSM & SM Performance'!$D$46,'Bonus Calculator'!G9:G21,0),1,0)
having some trouble with the logic here guys..any solutions?
hello guys
=OFFSET(INDEX('Bonus Calculator'!G9:G21,MATCH('DSM & SM Performance'!$D$46,'Bonus Calculator'!G9:G21,0),1,0)
having some trouble with the logic here guys..any solutions?
Last edited by step_one; 07-21-2011 at 02:11 PM.
The formula currently is missing a closing parenthesis:
=OFFSET(INDEX('Bonus Calculator'!G9:G21,MATCH('DSM & SM Performance'!$D$46,'Bonus Calculator'!G9:G21,0)),1,0)
It currently is looking for a cell in 'Bonus Calculator'!G9:G21 where a match occurs to what s in D46 of 'DSM & SM Performance' and offsetting 1 row and 0 columns...
Not sure what you are really trying to do though...
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
hello
thx u for your prompt response
i made one change, -1
=OFFSET(INDEX('Bonus Calculator'!G9:G21,MATCH('DSM & SM Performance'!$D$46,'Bonus Calculator'!G9:G21,0)),-1,0)
basically, i have a value in D46, and i wanted the offset to lookup one value above it. which it does.
thx u kind sir!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks