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?
You can highlight it by conditional formatting
or using a formula to count the quantity of that vehicle is duplicates
=COUNTIF(VehicleList,Vehicle)>1
