Forum Discussion
Using an If Statement within a VLookup across sheets
Hi, I have a work sheet which has multiple tabs showing vehicle data I also have a lookup tab so that when I enter a registration it will show me the relevant details and which branch the vehicle...
I want the vehicle to be displayed once it is active which is determined by a yes or no for example vehicle moved from one branch to another the second branch being where the vehicle is now active
I know that your current approach is use excel to manage it.
But I would suggest you using MS Access to manage it properly. Specially because MS Access can generate more easily a lot of different reports.
But I would suggest you using MS Access to manage it properly. Specially because MS Access can generate more easily a lot of different reports.
