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)
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.