pulling data color using vlookup
 

I need to pull the text color over from my source file to destination file.
I'm using vlookup to pull the data and would like to pull the text color over
also. I run a report each week and the colors may change. That is why I'm
trying to use vlookup to pull the color over also.

The command I'm using is:
=IF(ISNA(VLOOKUP(A69,[Rates.xls]Sheet1!$C$3:$D$101,2,FALSE))=TRUE,"",VLOOKUP(A69,[Rates.xls]Sheet1!$C$3:$D$101,2,FALSE))

Is there anyway to incorporate pulling over what the data color is in the
source file?

Any help would be appreciated?

Thanks
--
Baltimore Ravens

pulling data color using vlookup
 

See your other post.

Ravens Fan wrote:

I need to pull the text color over from my source file to destination file.
I'm using vlookup to pull the data and would like to pull the text color over
also. I run a report each week and the colors may change. That is why I'm
trying to use vlookup to pull the color over also.

The command I'm using is:
=IF(ISNA(VLOOKUP(A69,[Rates.xls]Sheet1!$C$3:$D$101,2,FALSE))=TRUE,"",VLOOKUP(A69,[Rates.xls]Sheet1!$C$3:$D$101,2,FALSE))

Is there anyway to incorporate pulling over what the data color is in the
source file?

Any help would be appreciated?

Thanks
--
Baltimore Ravens

--

Dave Peterson

pulling data color using vlookup
 

Thanks,
The internet crashed on me and I thought it didn't go through
--
Baltimore Ravens


"Dave Peterson" wrote:

See your other post.

Ravens Fan wrote:

I need to pull the text color over from my source file to destination file.
I'm using vlookup to pull the data and would like to pull the text color over
also. I run a report each week and the colors may change. That is why I'm
trying to use vlookup to pull the color over also.

The command I'm using is:
=IF(ISNA(VLOOKUP(A69,[Rates.xls]Sheet1!$C$3:$D$101,2,FALSE))=TRUE,"",VLOOKUP(A69,[Rates.xls]Sheet1!$C$3:$D$101,2,FALSE))

Is there anyway to incorporate pulling over what the data color is in the
source file?

Any help would be appreciated?

Thanks
--
Baltimore Ravens

--

Dave Peterson