Forum Discussion
Spreadsheet Help with Formulas Across Several Columns
One possible solution:
=INDEX('1C'!A:D,LOOKUP(B7,'1C'!A2:A509,ROW('1C'!C2:C509)),MATCH(B5,'1C'!1:1,0))
This time a slightly different solution.
=INDEX(API!$A$1:$U$91,MATCH(I7,API!$A:$A,0),MATCH(J7,API!$1:$1,0))
PERFECT AGAIN!!!!
Sorry for not replying sooner but I was out on a run at the end of the day. I just checked a few minutes ago this morning and it's perfect!!!!
I've been struggling with this for quite some time now but you cinched it up quickly.
After looking at it I was wondering if there was a way to have the 3 Foot, 6 Foot, and Even in a dropdown box where you currently have to manually type it. If you could help me with that one it would be a homerun!!! If not then it's still a homerun because you just don't know how long I've been trying to make this work.
Again, thank you very, very, very much!!!!
P.S. Whatever your employer is paying you isn't enough, if it were up to me I would easily double your pay!!!
Apply data validation to cells
P.S. Whatever your employer is paying you isn't enough, if it were up to me I would easily double your pay!!!Thank you very much. I can use every cent. May I will show your comment to him eventually. :-)
On the other hand, your problems were very easy to solve. Simple Excel standard.
Good Morning Detlef,
After getting everything setup I noticed a small glitch in the formulas for Trim. I've attached the updated workbook and when you look at the Gauge tab you'll see two different Trim settings. The problem is there are two tanks (3C & 3P) which have the same beginning and ending ullage because no fuel was transferred but due to the different Trims, the Observed Gallons are different. This is normal and to be expected when the beginning and ending ullages are different but creates a false inventory when no fuel was actually transferred from those tanks.
If you could help me with the formula for those tanks (1C, 2C, 3C, and 3P) to default the Trim to "3 Foot" if the beginning and ending ullages are the same it would be greatly appreciated.
I'm sorry to keep asking you for help and this will be the last time because everything else works flawlessly with this workbook thanks to you and I didn't notice this error until late yesterday when getting everything in place and trying the different scenarios did it become apparent.
Again, thank you for everything!!!
I'm sorry. I don't understand.
Hello Detlef,
PERFECT!!!!! PERFECT!!!! PERFECT!!!!
Homerun! No errors! Perfect game!!!!
I was blind but now I can see!
You've been a very huge, big help like you can't imagine!!!!
Your employer needs to quadruple your pay!!!!
It may have been easy for you but I was pulling hair out trying to remember this from years ago.
I had no problem with the pulldown problem you gave me a roadmap to, it was great solving one of my own problems.
Again, thank you very much for all your help with this.
Have a great day!
John