I am not an experienced excel person... trying to make a spreadsheet for a rural pool league. Using (cutting, pasting & modifying) from some other spreadsheets.
The following INDEX statement returns a 0 when the destination cell is empty... can I change the statement(add a parameter) to have it return an empty cell instead of the 0??
=INDEX('TEAM REGISTRATION'!$A$6:$Z$26,MATCH($A$15,'TEAM REGISTRATION'!$A$6:$A$26,),MATCH(C4,'TEAM REGISTRATION'!$A$6:$Z$6,))
Granted there may be completely different ways to accomplish what I am doing... But I have got my head around this statement, starting with a new one would be hard for me... not experienced in EXCEL
Any help in fixing this statement would be much appreciated.
Steve
The following INDEX statement returns a 0 when the destination cell is empty... can I change the statement(add a parameter) to have it return an empty cell instead of the 0??
=INDEX('TEAM REGISTRATION'!$A$6:$Z$26,MATCH($A$15,'TEAM REGISTRATION'!$A$6:$A$26,),MATCH(C4,'TEAM REGISTRATION'!$A$6:$Z$6,))
Granted there may be completely different ways to accomplish what I am doing... But I have got my head around this statement, starting with a new one would be hard for me... not experienced in EXCEL
Any help in fixing this statement would be much appreciated.
Steve