Showing results for 
Search instead for 
Did you mean: 
Level: Power Up

V-Lookup Calculator

Hi, I have a simple vlookup excel spreadsheet to work out a salary "position in range" function is that you can insert a pay band, and a salary, and it will pull data from another sheet to work out the 'position in range'


Is there an easy way to create this as an app through powerapp? (excell sheet attached)


Any help would be much appreciated


Many thanks


Super User
Super User

Re: V-Lookup Calculator

What you're wanting is definitely possible in PowerApps.  I did a really rough draft to show how this could work.  First step would be to take your data sheet and seperate that out and format it as a table in Excel.  Then upload that to OneDrive so you can reference that as a data source in your PowerApp.  Then all you need to do is use the Lookup function to get the correct data from your data source.  


I've attached the sample PowerApp and Spreadsheet as well as a screenshot of the lookup function.


Hope this helps!

Level: Power Up

Re: V-Lookup Calculator

Wow!  Thanks so much!

Super User
Super User

Re: V-Lookup Calculator

You're welcome.  Hoped that it helped.

Helpful resources


Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020


Power Platform World Tour

Coming to a city near you


PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Join PowerApps User Group!!

Connect, share, and learn with your peers year-round


Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 51 members 4,939 guests
Please welcome our newest community members: