VLOOKUP Returning a copy of a cell
I want to use VLOOKUP to return not just the value in the cell but also the
formating of the cell. For instance, if this is my table 1 Frog 2 Sheep 3 Cow and I do a VLOOKUP(2, A:B, 2, FALSE) I will get "Sheep". However, if Sheep is has a format that is for instance a strikethrough, then it will still show up as "Sheep". How can I return the format as well? Is there a way to use VLOOKUP to return a copy of the cell? Thanks, Kevin |
VLOOKUP Returning a copy of a cell
A formula can only return a value to a cell. It can not return formatting.
-- Biff Microsoft Excel MVP "Longeuaykr" wrote in message ... I want to use VLOOKUP to return not just the value in the cell but also the formating of the cell. For instance, if this is my table 1 Frog 2 Sheep 3 Cow and I do a VLOOKUP(2, A:B, 2, FALSE) I will get "Sheep". However, if Sheep is has a format that is for instance a strikethrough, then it will still show up as "Sheep". How can I return the format as well? Is there a way to use VLOOKUP to return a copy of the cell? Thanks, Kevin |
All times are GMT +1. The time now is 09:09 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com