IF this or this then get value from range a to b else get value from range x to z

Hi All

Would be nice if anyone can help!

I have the following setup:

Columns
P - Q - R - S - T - U - V - W

Column P I have the formula which is not working.

In one of the column from Q to U I have a value. So sometimes it's in column q sometimes in T and the other columns are empty (but have a formula in it).

and then I have the same from v to w. In one of the column is a value, sometimes in v sometimes in w.


With my formula in P I want to get the value from v to w but only if there is no value in v or w. If there is a value in v or w I want to get that value.

This is my formula:
=IF(OR((V31:W31="Robinsonlist");(V31:W31="Flagged AND"));(INDEX(V31:W31;MATCH(FALSE;(V31:W31)="";0)));(INDEX(Q31:U31;MATCH(FALSE;(Q31:U31)="";0))))

The forumale gets the error "a value used in the formula is of the wrong data type".

Many thanks for your help in advance!

please post an attachment as per the banner. its impossible for us to evaluate your formula with no data, or know what the correct answer is

Im convinced the formula is over complicated

Sorry, attached the excel file, the formula is under the tab "REVIEW ITEMS" in CELL P31.

in the 3 cells with value in I see that they are not entered as an array. (shift control enter) as they do not have curly brackets around them. Do you get the right answer if you do this?