• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Table Reference Formula

YPJunk

YPJunk

Member
What formula can I use in Tab 5, column E to show the flat stipend amount based on the inputs in column B and column D that are based on the table in Tab 6 (A2:E9)? Thank you for your help!

-Yvette
 

Attachments

  • Excel Formula Question - Table Reference.xlsx
    75.8 KB · Views: 7
In E2:
Code: 
=VLOOKUP(D2,'6. Pay Range Table'!$A$3:$E$9,MATCH(B2,'6. Pay Range Table'!$A$2:$E$2,0),FALSE)
copied down, but it will overwrite what you already have there.
You could wrap it in IFERROR to hide errors:
Code: 
=IFERROR(VLOOKUP(D2,'6. Pay Range Table'!$A$3:$E$9,MATCH(B2,'6. Pay Range Table'!$A$2:$E$2,0),FALSE),"")
 
You must log in or register to reply here.
Back
Top