Forum Discussion
Solved
Fill in a table from a reference table with conditions
Hi, I am relativly new to excel and I am hoping someone can help me solve the following: I have an overview table with all the details about our Diesel Usage including the Diesel Tank and 2 F...
Apologies for mis-understanding in first place. Attached a workbook with forumula in place on "Diesel Tank" sheet. Please let me if it helps?
Thank you.
I referenced all the columns in individual tables. How do I exclude the data not relevant to specific table? In other words if no Values have been entered in column F,G and or H in the individual tables.
Irrelevant data marked in red.
Apologies for mis-understanding in first place. Attached a workbook with forumula in place on "Diesel Tank" sheet. Please let me if it helps?