A challenge

[Harvey Waxman]

Two worksheets

If cell in Sheet #1 Col A matches corresponding cell in Sheet #2 put
value in Sheet #2 col F into Sheet #1 col H, otherwise create a new
row in Sheet #1.

Can it be done?

 

[Carl Witthoft]

Two worksheets

If cell in Sheet #1 Col A matches corresponding cell in Sheet #2 put
value in Sheet #2 col F into Sheet #1 col H, otherwise create a new
row in Sheet #1.

Can it be done?

Define "create a new row" and what, if anything, you'd like pasted
there.

But if you also mean, "don't mess with the current value in column H"
then there's no way to do this outside of a macro, because a cell
formula cannot (so far as I recall) place a value in some other cell.

 

[Harvey Waxman]

Define "create a new row" and what, if anything, you'd like pasted
there.

But if you also mean, "don't mess with the current value in column H"
then there's no way to do this outside of a macro, because a cell
formula cannot (so far as I recall) place a value in some other cell.

Sheet #1 has nothing in Col H so I'd just want to copy the value from
Sheet#2 col F.

Inserting a blank row is an effort to insure that the total number of
entries in Sheet #1 matches Sheet #2 which has some additional rows.

For example, if Sheet #1 has

A
100
200
300
400
500
600
700

and Sheet #2 has

100
102
200
300
301
400
500
600
700

The New Sheet #1

100

200
300

400
500
600
700

If the contents of Sheet #2 Col A could be copied to Sheet #1 ColA along
with the value in Sheet #2 Col F to Sheet #1 Col H, even better.

If copying to a third sheet would make it easier, that would be ok too.
Too confusing?

 

[Harvey Waxman]

After looking at what it would take to even come close using some online
resources I did it in a very inelegant fashion. I used a conditional
format to quickly spot where the differences were and just copy/pasted
what I needed. Not pretty but 10800 rows are done.

Thanks anyway.

 

[Bob Greenblatt]

Sheet #1 has nothing in Col H so I'd just want to copy the value from
Sheet#2 col F.

Inserting a blank row is an effort to insure that the total number of
entries in Sheet #1 matches Sheet #2 which has some additional rows.

For example, if Sheet #1 has

A
100
200
300
400
500
600
700

and Sheet #2 has

100
102
200
300
301
400
500
600
700

The New Sheet #1

100

200
300

400
500
600
700

If the contents of Sheet #2 Col A could be copied to Sheet #1 ColA along
with the value in Sheet #2 Col F to Sheet #1 Col H, even better.

If copying to a third sheet would make it easier, that would be ok too.
Too confusing?

A formula can ONLY return a value to a cell. Carl is correct in that this is
the only thing a formula can do. What you are requesting will require a
macro or Apple Script.