I have a formula that is pretty long. It works, but I have to propagate it
into 500+ other cells and the editing will take a long time.

Anyway, please take a look and see if there is any way I can shorten this
up. I'm sure there is, but I'm at my limits.

=IF(ISNA(IF(ISNA(VLOOKUP(A6,A99:A168,1,FALSE)=A6), (0+VLOOKUP(A6,G99:H168,2,FALSE)),IF(ISNA(VLOOKUP(A 6,G99:G168,1,FALSE)=A6),(0+VLOOKUP(A6,A99:B168,2,F ALSE)),VLOOKUP(A6,A99:B168,2,FALSE)+VLOOKUP(A6,G99 :H168,2,FALSE)))),0,IF(ISNA(VLOOKUP(A6,A99:A168,1, FALSE)=A6),(0+VLOOKUP(A6,G99:H168,2,FALSE)),IF(ISN A(VLOOKUP(A6,G99:G168,1,FALSE)=A6),(0+VLOOKUP(A6,A 99:B168,2,FALSE)),VLOOKUP(A6,A99:B168,2,FALSE)+VLO OKUP(A6,G99:H168,2,FALSE))))

Thanks,

Kevin