Offset formula

I have attached a sample of the spreadsheet I need help with. The cell/cells in question are f32:f36 on the first tab.

Question #1 Can someone explain to me how this formula works or what it does.

Question #2 Is when I enter the required information in cells a32:e32 it enters an N/A in cell f32. When I than click on cell F32 and than click on the formula bar and hit enter the information populates. Why does this happen?

Any questions or need additional info please let me know.

FWIW I would suggest a revision to a non-volatile version:

Please Login or Register  to view this content.

The above basically creates an embedded INDEX (highlighted in red) of 0s and 1s - one number for each row of data on the Digitial sheet - the 1 will appear where all conditions hold True.
The "outer" INDEX finds the first 1 within the embedded INDEX and uses that to establish the row position of the value to be returned, the final MATCH is used to establish the column from which the value is to be returned (based on Qty).

Put this formula in F32 instead...

Please Login or Register  to view this content.

copied down

It basically indexes the table range: Digital and Flexo Pricing'!$J$4:$Y$366

and finds matches corresponding to C32, A32 and E32 in ranges, 'Digital and Flexo Pricing'!$J$4:$J$366, Digital and Flexo Pricing'!$F$4:$F$366 and 'Digital and Flexo Pricing'!$I$4:$I$366, respectively, then finds closest match for B32 in 'Digital and Flexo Pricing'!$J$3:$Y$3 and returns the intersecting value for all these matches.

The Index() method is prefered over the Offset() method, because Offset() is volatile function.