pulling data color using vlookup

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
See your other post.

Ravens said:
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
Click to expand...
 
Thanks,
The internet crashed on me and I thought it didn't go through
--
Baltimore Ravens


Dave Peterson said:
See your other post.

Ravens said:
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
Click to expand...
Click to expand...
 
Back
Top