Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

I'm not sure I understand your example. If your columns and rows are alligned so that name and address are in the same column on both sheets, you can do the follwing:

Create a third sheet with all the columns. put the following formula and drag it where you need it. =IF(ISBLANK(Sheet2.A2),Sheet3.A2,Sheet2.A2)

This will always put the value from sheet2, unless it's blank in which case it will get the data from sheet3. You can probably add a bit more in it so that it wont show 0's where both sheets have a blank in a field.