If statement across tabs in a workbook

[auroraH]

Needing to use a if statement for a value on one tab that will match the same value on another tab in a certain column. if (AE4,brand!A1:A5,25,IF(AE4,Brand!A7:A10,35,IF(AE4,Brand!A11:A20,44))). any clues why it will not work?

or can I use this:
IF(Band!A2:A59,AE4,Band!R3:R59)

 

[paulsolar]

Hi

I'm a little confused as to what you are trying to achieve sorry, could you explain what you are trying to do a little more clearly please.

Looking at your if statement in do not understand the question.

Normally an if statement requires a question say if a1=x is true, then b is the answer, if a=x is false, then c is the answer This would be written =if(A1=x,b,c)

Where x could be a number of things, b could be a cell reference or a number of things & c could be a cell reference or a number of thing.

Regards

Paul

 

[Trouttrap2]

I think what you are trying to do is this:
=IF(OR(AE4=brand!A1:A5),25,IF(OR(AE4=brand!A7:A10),35,IF(OR(AE4=brand!A11:A20),44,"not found")))
Enter with CTL+SHFT+ENter. Because its an array.
Otherwise, for more help, we will need to understand your logic better.

 

[ukmikeb]

Hi

Probably :-

=IFERROR(LOOKUP(MATCH(AE4,Brand!$A$1:$A$20,0),{0,6,11,21},{25,35,44}),"")

hth

 

[auroraH]

Paul, thanks for the reply. I was able to get it to work using a Vlookup statement. I have ranges in the A Column and they are set apart by a blank cell to create a group. Three to be exact. I wanted to have the AE4 cell on one tab look at the Band tab and if the match use in a certain range in column A then return a predefined number.