pulling data color using vlookup

[Guest]

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

 

[Dave Peterson]

See your other post.

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

 

[Guest]

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

See your other post.

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