I would like to write an If statement in the attachment. I would like cell B3 to look at cell A3 and based upon which amount it is closest to in column E, provide the average listed in column D. For example, since A1, 14.63% can is closest to 15%, the amount in cell B3 would be 2.5% or D5.
Thanks for the help.
I would use logic so that you can use the vlookup. Swap columns D and E then put the the following formula in Cell B3
Please Login or Register to view this content.
=INDEX($D$3:$D$8,MATCH(MROUND(A3,0.05),$E$3:$E$8,1))
Or maybe this formula works
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
The Vlookup formula almost works. It is selecting the percentage in column E below the the one it should select. For example, B3 should be 2.5% as 14.63% would round up to 15%. Is there a way to fix that?
Changethe TRUE to FALSE TRUE is for a sorted list, FALSE is for an exact match
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks