I have a row B22:F22 (and B23:F23 etc) which contains the results of a search and comprises 4 false answers and one true answer which is a text value (VG, G, F, P, VP - very good to very poor) and the location of this answer could be in any og the 5 columns. I need to extract this correct answer into the corresponding row in column G. I have tried combinations of If, Index, Match and Hlookup but seem to be doing something wrong.