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


Power Automate Community User Group Member Badge

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


Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020


Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 416 members 6,672 guests
Please welcome our newest community members: