How to reference a cell value
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
|