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...
Hi
Thanks for responding to me would I not have the same problem on one sheet though? If I combined all on one sheet how would I get my lookup just to show the active vehicles when there are duplicates?
Thanks for responding to me would I not have the same problem on one sheet though? If I combined all on one sheet how would I get my lookup just to show the active vehicles when there are duplicates?
Depends on how you want to determine which vehicle to display?
Perhaps something like the attached, where I have added slicers to filter the table?
- 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.
