cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
stumchale
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

S

3 REPLIES 3
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!

stumchale
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

Announcements
thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

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

fifthimage

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: