Hi.
I would like some help please with approval limits
On the sheet “Invoice Approval” I would like a formula in the red cell which looks at Cell C6 and then returns what level of approval is required from the “Approval Limits” tab.
What is the easiest way to do this?
I have attached an example.
Paul
My suggestion would be to change your limits table to something a bit easier to use and then go with index/match. I've attached an example (note, the minimum limits in column D are for information only, not used in the calculation.
Do you mean?
Formula:
Please Login or Register to view this content.
Replace the +100 in d11, with the number 101.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
@Fotis, I think it needs a -1 match type so you need to have the list going from level 1 to level 4 with a big number for level 1.
Hi,
Thanks guys for the solution. I think ragulduy was correct as Fotis didnt work at first.
Paul
You are correct!(I dream the sea!!)Originally Posted by ragulduy
Me too (my holiday starts in 30 minutes).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks