Help with linking cells ..

[used2reg]

Hello

I have an excel sheet (version 2010) that has a few sections that you can add in names (via drop down box). I also have a spot where i want these names to populate - on a second sheet.

Ex
Truck #1:
1. _____
2. _____
3. _____
4. _____
5.______

Truck #2:
1. _____
2. _____
3. _____
4. _____
5.______

Truck #3
1. _____
2. _____
3. _____
4. _____
5.______

Truck #4
1. _____
2. _____
3. _____
4. _____
5.______
6.______
7.______
8.______

My problem is when I refer to the first worksheet from the second worksheet it shows blanks where there are no names. For example i want the second sheet [ LOC ] to show the names that appear under Truck #1, #2, #3, #4 - but truck #1 may not always have names under it?

Sample Excel file attached -




Thanks

[TMS]

Rather than saying just: =Incident!G9

Use: =IF(Incident!G9="","",Incident!G9)

and the same for the other references.


Regards, TMS

[used2reg]

maybe i am, missing something; but not working fior me....

[TMS]

In cell K10 on the Loc tab, you have: =Incident!G9 which returns 0 when Incident!G9 is blank.

=IF(Incident!G9="","",Incident!G9) will return a blank until something is entered in Incident!G9.

Take the same approach in any cell that has a "simple" link to another sheet/cell.

Regards, TMS

[used2reg]

ok... i see...

i was also looking to see if there is a awy for me to Fill out Rows 25 through 44 on the LOC sheet from the information on Incident -
D14:D20; AD14:Ad20; D26:D34; AD26:AD30; D40:D43; AD40:AD43

BUT the but thing is i would like to have the named on the Incident tab come over to the LOC tab only if the cell is filled - but they may not all be filled out?

[TMS]

C25: =IF(Incident!D14="","",Incident!D14)
AK25: =IF(C25="","",VLOOKUP(C25,DDL!B:J,3,FALSE))

Unfortunately, because of the way you have set up the sheets, you'll need to drag down in blocks


Regards, TMS

[TMS]

Thanks for the rep