samedi 5 mai 2018

If excel matches 3 values then return 4th

This is my first time posting on any website, so please be gentle lol!

I am trying to figure out what forumula i need to help with the attached tabs;

Main Sheet

Data Dump CSV

Goal: to identify how many blocks are due for each block length, at each selected time for each service type. The current UI we have is really poor. this is more user friendly.

My solution?

in each cell there will be a formula to search each time slot for each service type and return the accepted amount for standard/large vehicles from the data dump CSV.

I'm self taught on excel and know some basic macros and formulas however i have admitted defeat here.

I hope this makes sense. I only need the formula to pick up one service type i can amend to suit where necessary.

Thanks in advance for those who take the time to assist.

James

Aucun commentaire:

Enregistrer un commentaire