Three dimensional lookup

[rajncajn]

Need advice on Excel. Does anyone know if a three dimensional formula is possible in 2010? I need to pull from a named range (table) based on a number and then have it further pull from a cross section of a size as the column heading and a multiplier as the row title. Ex: table named range is test 123. When test 123 is entered in a cell I need excel to go to that table specifically and further pull the price from a specific size and multiplier. Any ideas????

 

[Tinbendr]

Any ideas????

VLookup, but we're going to need some specifics before we can help further.

 

[TheCman81]

It's prob going to be SUMPRODUCT, but will need some data please

 

[rajncajn]

I tried to upload a sample of the spreadsheet, but I can't so not sure how to get the sample data in a way that will make sense.

 

[TheCman81]

Download excel janine from here http://www.mrexcel.com/forum/showthread.php?t=628649

Youll be able to post your workbook from that