To save time, there are some standard unit costs that I want to pull through from another tab in the same worksheet.
For example Consultant 'Joe Bloggs' has a day rate of £500. So if the selections from the drop down lists in two of the columns on the costing sheet match 'Joe Bloggs' and 'Consulting Fees' I want the unit cost to automatically populate as £500.
I found a solution that described using the CONCATENATE function to merge two values into a 'helper' column in my look up table. It partially worked, but not all the values were coming through correctly. I've tinkered with it and now none of the values are coming through at all!!
Can anyone spot where I may have gone wrong on the attached file??
(NB: I did try this using IF and AND functions which does work, but the number of variables became too large)