## Let me see if I can explain this...

I have 4 sheets (Proposal 1, 2, 3 and Deatail Sheet). Detail sheet has two
columns, the first is dived up into 3 parts (each 18 cells tall) to export
data to Proposal 1, 2 or 3 depending on the amount of data. The second column
will be used to finnish (append) where the first column left off. The second
column will only have one line of information.

This is my formula:

=IF('Detail Sheet'!C81=G16,'General Proposal 1'!A1,IF('Detail
Sheet'!D28="",'Detail Sheet'!C81,'Detail Sheet'!D28))

A1 = represents just a blank data field
C81 = is the data that is supposed to be at the very end
G16 = is the line above where the formula goes
D28 = The data that goes first ( can be many lines of data)

The problem is once it reaches the end of the data list from column one, the
data from column two does fine ,but , then repeats every other line.

I've tried using OR(EXACT, like so:

=IF('Detail Sheet'!C81=OR(EXACT('Detail Sheet'!C81,G16:G22)),'General
Proposal 1'!A1,IF('Detail Sheet'!D28="",'Detail Sheet'!C81,'Detail
Sheet'!D28))

but I get #VALUE!