VLOOKUP Formula For Price Sheet

I've tried to figure this out for the last hour but I can't seem to figure it out, as I'm not too knowledgeable in excel. Any help is greatly appreciated.

The task: create price sheet that calculates pricing based on 2 criteria - quantity, and production time.

There are two worksheets. #1 is the main calculator, #2 is the price sheet, broken down with time (in hours) on the left column B, the quantity across the top in row 1. There are then boxes with different prices based on both the hours and quantity of products.

On worksheet 1, I have specified quantity in C6, and time in C8. How do I pull a price in to F8 that calculates based off the time and quantity filled out on sheet 1?

Please help!

Thank you!!

Something like:

=INDEX(Sheet2!$A$1:$X$10,Match($C8,Sheet2!A$1:$A$10,0),Match($C6,Sheet2!$A$1:$X$1,0))

where Sheet2, A1:X10 contains your table price sheet....

Adjust ranges as necessary. Note: the first Match() looks up column B, the Second MATCH() looks up Row 1...

.. Note also, the lookup is for exact matches....

Match can give you the next value if an exact match is not found

=INDEX(Sheet2!$A$1:$X$10,Match($C8,Sheet2!A$1:$A$10,0),Match($C6,Sheet2!$A$1:$X$1,1))

if your columns have values like
0.....10.....20.....30.....40.....50

then MATCH(15,<column range>,1) will return 1, since 15 is between 10 and 20 and thus is matched to the second column.

You may have to rearrange your column headers a bit for this to work. If you need help, post a data sample.