EXCEL FORMULA HELP

Question

&nbsp;
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 constant&nbsp;
SHEET 2: This is my driver allotment sheet for the trips. So if I would request for a formula where, in this sheet, if I just write the name of the starting point (POINT A) and the name of the ending point (POINT B), the kms taken to drive to such distance should automatically pick up from my source sheet (SHEET 1)
Please help!
&nbsp;

Delete

&nbsp;

haytham amairah · Answer

Benazir,
&nbsp;
I've updated your attached file with the solution, all you need is a simple VLOOKUP.
Please find the attachment file.
&nbsp;
Hope that helps.

benazir tehrani · Answer

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!&nbsp;&nbsp;

haytham amairah · Answer

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.
&nbsp;

benazir tehrani · Answer

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 ?

haytham amairah · Answer

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&nbsp;features in Excel, so I advise you to learn it.

Forum Discussion

EXCEL FORMULA HELP

5 Replies

Resources