LinkBack URL
About LinkBacks
Why not? Work for me....
It will find lowest value and +1 will bring propper result
Edit: you are right.. but this might work:
=IF(ISNA(MATCH(D4;$A$1:$A$26;0));INDEX($B$1:$B$26;MATCH(D4;$A$1:$A$26;1)+1);VLOOKUP(D4;$A$1:$B$26;2;TRUE))
Why not? Work for me....
It will find lowest value and +1 will bring propper result
Edit: you are right.. but this might work:
=IF(ISNA(MATCH(D4;$A$1:$A$26;0));INDEX($B$1:$B$26;MATCH(D4;$A$1:$A$26;1)+1);VLOOKUP(D4;$A$1:$B$26;2;TRUE))
Last edited by zbor; 06-09-2009 at 04:28 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks