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 would combine all data on a single sheet with an added "Fleet" column and ditch the individual Fleet sheets, they lead to a lot of unnecessary complexity in your formulas.
- 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?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
You can highlight it by conditional formatting
or using a formula to count the quantity of that vehicle is duplicates
=COUNTIF(VehicleList,Vehicle)>1
