Hi All,
I am trying to map transaction count to pricing tier based on reference table which has pricing tier for every range of transaction counts...Please find attached the sheet...Can you please help me here..
Thanks,
Arun
Hi All,
I am trying to map transaction count to pricing tier based on reference table which has pricing tier for every range of transaction counts...Please find attached the sheet...Can you please help me here..
Thanks,
Arun
Cell D14 formula , Drag down
Formula:Please Login or Register to view this content.
In D14
=LOOKUP($C$14:$C$18,$K$2:$K$7,$J$2:$J$7)
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
@chandramouliarun You're Welcome. Glad to help . Thank You for the feedback and rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks