Reference multiple rows and columns

[Stephenosn]

I'm trying to change a formula I currently use that references cells in only one row. =IF(ISNA(MATCH($B5,June!B$3:B$7,0)),MAX(C$4:C4)+1,"")

Is it possible to change the June!B$3:B$7 to also reference columns B through Z and rows 3 through 7?

Thanks for taking a look.

 

[JoeMo]

MATCH returns the relative position of the match within the lookup array so the lookup array must be within a single row or single column. Like June!B$3:B$7 or June!B$3:Z$3, but not June!B$3:Z$7.

 

[PCL]

Perhaps try

=IF(SUMPRODUCT(--(June!B3:F7=$B6))=0,MAX(C$4:C5)+1,"")

 

[Stephenosn]

Could I use a Vlookup function with the match function?

 

[Stephenosn]

PCL I'm trying out your formula but keep getting a circular dependency warning.

 

[PCL]

Where did you put it, which cell and which sheet ?
Personally I put it in sheet1 G8

 

[Stephenosn]

I put it on a sheet labeled NamesUsed. I started in cell C5. I finally found a formula that worked. =if(sumproduct(June!$B$3:$Z$7=$B35),"",max(C$34:C34)+1). It looks like you had the answer the entire time. Thank you for your help.