I am trying to write a formula that will allow me to out put a specified text value from one cell but am receiving an error message #VALUE!. I can only get this to work if the values in the cells are numbers. Any suggestions?
I am trying to look at cell B7 and if it is equal to cell B52 through B73 it will output the corresponding cell in D52 through D73. It works correctly as long as the values in D52 through D73 are numbers, but if the value is a text I recieve #VALUE! as an output