match, copy, paste, & color
 

Hi Folks,

I'm working with two sheets, "Rate Check" & "Union Contract Raise Report".
With "Rate Check" column A I want to find the matching value in "Union
Contract Raise Report" column A, copy the given rows value from "Union
Contract Raise Report" column F, paste the value into "Rate Check" column D
for that row, then format the new column D value Blue so the user knows it
has been changed.

If there is no matching value between "Rate Check" & "Union Contract Raise
Report" for a given row, then simply move on to the next row until the end is
reached.

Any help is always greatly appreciated.

TIA!

match, copy, paste, & color
 

Hi,

This requires 2 steps.
First put this in D1 and drag down as required
=IF(ISNA(VLOOKUP(A1,'Union Contract'!A1:F39,6,FALSE)),"",VLOOKUP(A1,'Union
Contract'!A1:F39,6,FALSE))

Select the cells woth your formula in and then
Format|Conditional format
Cell values - Greater than and enter ""
Note there is no space between the quotes
Pick a colour

Mike

"Stephen" wrote:

Hi Folks,

I'm working with two sheets, "Rate Check" & "Union Contract Raise Report".
With "Rate Check" column A I want to find the matching value in "Union
Contract Raise Report" column A, copy the given rows value from "Union
Contract Raise Report" column F, paste the value into "Rate Check" column D
for that row, then format the new column D value Blue so the user knows it
has been changed.

If there is no matching value between "Rate Check" & "Union Contract Raise
Report" for a given row, then simply move on to the next row until the end is
reached.

Any help is always greatly appreciated.

TIA!

match, copy, paste, & color
 

hmmm. i see where this is going but I think i need to lookup the value in my
"Rate Check" column A, as the columns is populated with it's own VLOOKUP and
I think your VLOOKUP is seeing the formula instead of the value.

"Mike H" wrote:

Hi,

This requires 2 steps.
First put this in D1 and drag down as required
=IF(ISNA(VLOOKUP(A1,'Union Contract'!A1:F39,6,FALSE)),"",VLOOKUP(A1,'Union
Contract'!A1:F39,6,FALSE))

Select the cells woth your formula in and then
Format|Conditional format
Cell values - Greater than and enter ""
Note there is no space between the quotes
Pick a colour

Mike

"Stephen" wrote:

Hi Folks,

I'm working with two sheets, "Rate Check" & "Union Contract Raise Report".
With "Rate Check" column A I want to find the matching value in "Union
Contract Raise Report" column A, copy the given rows value from "Union
Contract Raise Report" column F, paste the value into "Rate Check" column D
for that row, then format the new column D value Blue so the user knows it
has been changed.

If there is no matching value between "Rate Check" & "Union Contract Raise
Report" for a given row, then simply move on to the next row until the end is
reached.

Any help is always greatly appreciated.

TIA!