I am trying to create a formula to lookup and match two values and return a corresponding delivery date, if those two values are matched.
If there is no corresponding delivery or values cannot be match, the result should state 'No Delivery'
I've attached a basic spreadsheet example.
I'd like to match the values in column A with column E, the value in column B with column F, and return into column C the data from column G.
If there is no data to return, then the result would state 'No Delivery'.
If anyone could help it would be much appreciated.
Thanks
Bookmarks