Forum Discussion
EXCEL FORMULA HELP
Hello ALL .....Please help!
Please find attached an excel.
SHEET 1: Is the data showing the KMS taken to go from Point A to Point B. This is my source data sheet and will be const...
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 ?
