hiii...
Require vlookup formula with approximate match in cell B31 based on table array C2:D16.
I think its the formatting issues due to which formula not giving expected results..
attached here is the query file
Kindly help.
Thanks.
hiii...
Require vlookup formula with approximate match in cell B31 based on table array C2:D16.
I think its the formatting issues due to which formula not giving expected results..
attached here is the query file
Kindly help.
Thanks.
And what should the outcome be?
Try adjusting your formula like this:
=VLOOKUP(A31*24,C2:D16,2,TRUE)
May be this
Formula:Please Login or Register to view this content.
☚ Click ★ just below left if it helps, Boo?ath?
Hii MaraisV & boopathiraja,
Thanks but another issue exist..it sums upto 24 hours only..after that it start from 00 hours..example if total hours worked is 26 hours it will show 2 hours and accordingly the credit calculation will go wrong..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks