Excel idiot here…..

In the pic below, on the sheet on the right, I am choosing two values in columns E and F from validation (reference the sheet on the left) and would like to return a value from a sheet on the left.  i.e.  If I choose “ELDC” and “OT Rate” on the right, I would like choose the proper value from the table on the left…in this case $31.76.  Any help is appreciated!!!

​Excel idiot here…..In the pic below, on the sheet on the right, I am choosing two values in columns E and F from validation (reference the sheet on the left) and would like to return a value from a sheet on the left.  i.e.  If I choose “ELDC” and “OT Rate” on the right, I would like choose the proper value from the table on the left…in this case $31.76.  Any help is appreciated!!!    Read More

​