Forum Discussion
Spreadsheet Help with Formulas Across Several Columns
In cell B5 it currently says 3 Foot. In different scenarios it can also say 6 Foot or Even. I need cell C7 to reference the appropriate column on tab 1C in regards to Even, 3 Foot, or 6 Foot, then I need it to reference the corresponding number in cell B7 that corresponds to the same number on tab 1C under the Ullage column.
I'm using LOOKUP right now which works fine with only two columns but I need it to work with several columns under different scenarios. When looking at
Below is tab 1C and the tabs I was talking about which should make this much easier to understand. Basically, when I enter the Ullage in cell B7 it needs to reference the Even, 3 Foot, or 6 Foot column and give me that number. For example, the Ullage is 1.03 and the Trim is 3 Foot, the correct number is 302142. If I can get some help with this I can make the rest of this spreadsheet work because the formula I'm looking for will work for the rest of this spreadsheet.
Also, is there a way to make the Even, 3 Foot, and 6 Foot a dropdown selection instead of having to type it directly in all the time?
My knowlegdge of Excel is severely limited and any help you can provide will be greatly appreciated.
One possible solution:
=INDEX('1C'!A:D,LOOKUP(B7,'1C'!A2:A509,ROW('1C'!C2:C509)),MATCH(B5,'1C'!1:1,0))
- In regards to your inquiry about creating a drop down selection list in excel.
Type the words Even, 3 Foot and 6 Foot (in three separate cells) on another area of your spreadsheet, then - once you're in the cell where you want the list - go to Data Tab>Data Validation dropdown>Data Validation>Allow dropdown>List>Data dropdown> Choose the list you typed earlier. Hit OK. Hi John
It's better to provide a workbook than a bunch of photos.
I agree completely. Please see attached workbook. If you have any questions, please don't hesitate to ask.
One possible solution:
=INDEX('1C'!A:D,LOOKUP(B7,'1C'!A2:A509,ROW('1C'!C2:C509)),MATCH(B5,'1C'!1:1,0))
