Forum Discussion
EXCEL FORMULA HELP
Benazir,
I've updated your attached file with the solution, all you need is a simple VLOOKUP.
Please find the attachment file.
Hope that helps.
Hello Haytham,
Thank you very much!
Now, in a scenario where the Column A is not constant (Please refer to the attached sheet, DATA, Row 5,6,7). How will that formula change on the next sheet?
Thank you again for your help!
In this case, you have to use an array formula to take into account the pick up location.
Please find the solution in the attached file.
- Yes...this looks perfect.
Just one small addition...in the Driver Sheet, you had initially made Column E as a drop down option? Can you do the same for Column D ?Yes of course, please find the attached file!
I've used something called: https://support.office.com/en-us/article/Apply-data-validation-to-cells-29fecbcc-d1b9-42c1-9d76-eff3ce5f7249, and it's one of the essential features in Excel, so I advise you to learn it.