Dear Sir,
I wanted help to find out list of our own vehicles from OWN VEHICLE sheet.
My Sheet3 Column A that is account head should show as ExpsFuel if Vehilces from our Own Vehicles and if not from Own Vehicles then vendor name from Entrybook should come.
Eg : I will apply lookup in Sheet3 Column A for Vehicle no : from Sheet3 Column B If that vehicle from Own Vehicles List then account head should show as ExpsFuel else vendor name from Entrybook Column B.
I wanted help to find out list of our own vehicles from OWN VEHICLE sheet.
My Sheet3 Column A that is account head should show as ExpsFuel if Vehilces from our Own Vehicles and if not from Own Vehicles then vendor name from Entrybook should come.
Eg : I will apply lookup in Sheet3 Column A for Vehicle no : from Sheet3 Column B If that vehicle from Own Vehicles List then account head should show as ExpsFuel else vendor name from Entrybook Column B.