I am trying to list info from another sheet but I do not want to refernce row
that have a zero value in a certain cell. but the I also do not wasnt to
skip lines. i am trying to make this spread sheet so the zero rows can
change at a later date and automaticaly update the other tab. this is
important becaust this info is referencing to mappoint.
--
Thanks,
Brennan

Hi Brennan,

To reference rows from another sheet in Excel while skipping rows with zero values in a certain cell, you can use the combination of the IF and INDEX functions. Here are the steps:

1. Open the sheet where you want to display the referenced data.
2. In the cell where you want to display the first value, type the following formula:
   Code:

   =IF('SheetName'!$A$1=0,"",'SheetName'!$A$1)

   , where 'SheetName' is the name of the sheet where the data is located, and $A$1 is the cell that contains the value you want to reference. This formula checks if the value in cell A1 of the other sheet is zero. If it is, it displays nothing. If it isn't, it displays the value.
3. Copy the formula to the rest of the cells where you want to display the referenced data. The formula will automatically adjust to reference the correct cells on the other sheet.

Note that you can change the cell reference in the formula to match the cell where the zero value is located. Also, if you want to reference a range of cells instead of just one cell, you can use the INDEX function with the IF function to skip rows with zero values. Here's an example formula: , where $A$1:$A$10 is the range of cells you want to reference, and ROW() returns the current row number. This formula checks if the value in the current row of the range is zero. If it is, it displays nothing. If it isn't, it displays the value.

I hope this helps! Let me know if you have any further questions.

Hi Brennan,

To reference rows from another sheet in

Code:

Microsoft Excel

while skipping rows with zero values in a certain cell, you can use the

Code:

IF

function along with the

Code:

INDEX

and

Code:

MATCH

functions. Here are the steps:

1. Open the sheet where you want to list the information from another sheet.
2. In the cell where you want to start listing the information, enter the following formula:
   
   
   Code:

   =IF('SheetName'!$C1=0,"",'SheetName'!$A1)

   
   
   Replace 'SheetName' with the name of the sheet where the information is located. Replace $C1 with the cell reference where the zero value might appear. Replace $A1 with the cell reference where the information you want to list is located.
   
3. Copy the formula to the cells below to list all the information you need.
   

This formula checks if the value in the cell on the other sheet is zero. If it is, it returns an empty cell. If it isn't, it returns the value from the cell you want to list.

If the information you want to list is not in a consecutive range of cells, you can use the

Code:

INDEX

and

Code:

MATCH

functions to find the correct cell. Here's an example:

Code:

=IF('SheetName'!$C1=0,"",INDEX('SheetName'!$A:$D,MATCH($A1,'SheetName'!$A:$A,0),4))

This formula looks for the value in cell A1 on the current sheet in column A on the other sheet. When it finds a match, it returns the value in the fourth column of the same row.

I hope this helps! Let me know if you have any further questions.