Hi guys,
Just wondering if someone could have a look at the attached workbook. I am trying to build a Holiday Booking spreadsheet and am using multiple VLookups (Not sure if its the most efficient, so that could be my problem). There are two Vlookup arrays (The first looks at the raw data and sorts it into days, the second looks at this and sorts into shifts) and the second VLookup will not display the result, just brings up "#NUM!". I have tested the search as a normal VLOOKUP and it works fine... Not sure what i am missing.
Any help on this would be much appreciated
Cheers
Laz
Bookmarks