Hi everyone,
I am trying to use the following formula:
=IF(ISERROR(VLOOKUP($C15;'Copy of Analysis 9'!A:Q;2;FALSE));VLOOKUP($D15;'Copy of Analysis 9'!A:Q;2;FALSE);"0" )
I want to try to look at C15 and if I can't find in C15 then look at D15 and return the result from the 2nd column in the look up table.
Am I doing something wrong as I am getting the #N/A when the formula should return the result linked to C15
Can anyone help please?
Adele
Bookmarks