Ok, as far as your question -
"...is there a way to maintain the VLOOKUP formula in the cell and also allow for manual contractor details to be entered?"
Not that I know of. But I've attached a possible solution. I changed your Contractors data range to a Table named Contractors_Tbl (It's in the Name Manager). I also created named ranges for each colummn in that table (also located in the Names Manager).
I referenced your VLOOKUP formulas to the Contractors_Tbl. Your formulas now look like this and changed FALSE to 0 since it means the same thing "exact match" in this function. Saves typing and typos (for me anyway).
All you need to do with this set-up is enter a new name and info into the table on your Contractors tab. Just start typing in the first empty cell in column A and go from there.
Your dropdown list will automatically see the new Contractor entry...you know the rest
Hope I didn't over explain - just didn't know your experience with tables...
Bookmarks