Ok additional question - what if i wanted to add another variable to teh formula.
What if the cell the Vlookup starts with is blank, and i want the answer to say something else? how would i go about adding this into the formula - i've tried variations of adding an additional IF etc... but with no luck
Any help always appreciated![]()
Bookmarks