How to reference a cell value

[Jmoney2290]

Hello,



I am having a difficult time creating a formula that can reference a value from a chart I have made. I have attached my file, and where the section labeled "Pipe Dimension" there are some cells highlighted in yellow. For the cell labeled "Odp" I used the VLOOKUP function ,and it was just a matter of pulling one value from my chart when I used my drop down list under "Size Pipe". The issue I am having is the cell labeled "Idp" and "Ida" need to reference the sizes based on the drop down list for "Pipe Size" and the drop down list for "Schedule" I know this might sound confusing, but I'm trying to figure out the best way to choose a pipe size and based on the schedule size for that pipe it will return the corresponding value from the "Pipe Dimension Chart".

Thank you,

Josh

[macropod]

You refer to:

the drop down list for "Pipe Size" and the drop down list for "Schedule"

but what I see is two dropdown lists, one below each of your "Pipe Size" entries and none for "Schedule" (which occurs in three places). Please clarify and be more specific.