I have two workbooks containing details of a car fleet. I am using a simple vlookup to look at the vehicle registration on workbook 1 look it up in work book 2 and return the vehicle drivers name from a column.
Everything works fine unless the lookup finds a blank cell in workbook 2 under the drivers name, where correctly it returns a blank.
I would like to combine an if statement which says vlookup(workbook1!vehicleregistration,workbook2!columna:d,3,false(ifblank (workbook2!columna:d,4,false). I'm not sure of the correct syntax.
Any help would be appreciated
Bookmarks