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

[dffkp]

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!

 

[Special-K99]

This doesnt make sense.

"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. "

You want a formula in P to get a value from V:W if there is no value in V:W
Then you wont get a value if theres nothing in it will you?

Supply some example data with expected results.