Hi.
I'm trying to get a formula to give a response if a given cell matches any of the values in a row.
This formula does not work:
B2=IF(A2=D2:D6;D1;IF(A2=E2:E6;E1;0))
Spreadsheet:
see attachment
I know one solution to the problem but it cannot be the right one...
B2=IF(OR(A2=D2;A2=D3;A2=D4;A2=D5;A2=D6);D1;....
I'm using Excel 2007, and it must be a way to easily check one cell up against a row or column. The solution with "OR" statement will be extremely long for a long list, and many columns.
Tommy
Bookmarks