Hello p45cal,
Thanks for the reply and offer to improve/add to what you have already provided.
I must admit I did try to add an extra hard coded value, which did not work. I thought I must be doing something wrong, which is why I asked about adding an extra value.
As the file I use is an .xlsx and consists of over 30 workbooks I would prefer not to go down the macro path or add a table of lookup values.
Your original, hard coded, three value formula does what I require and is simple to follow and easy to copy down a column.
I suppose if the formula could be made "... a bit cleverer ...", my only comment would be that if it does not match the three already hard coded values then return a blank cell.
I am more than happy with what you have provided so far and unless making a change to return a blank cell is a quick, easy addition I am happy to leave it as is and mark it solved again.
Regards, Dave T
|