catmanjake
New Member
- Joined
- Jul 20, 2010
- Messages
- 3
Is there a way to use a Vlookup table or something similar that would pull Values as wells as Formats? Thanks for any help you can give me.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Vlookup to pull Value & Formats
- Thread starter catmanjake
- Start date
You can return the format of a cell with the following formula:
=CELL("FORMAT",A1)
You can find out what the code means by looking up the CELL function in the Excel help menu.
I don't know if you can use this formula with a VLOOKUP. When I tried, it didn't work. Maybe someone else knows...
Pete
=CELL("FORMAT",A1)
You can find out what the code means by looking up the CELL function in the Excel help menu.
I don't know if you can use this formula with a VLOOKUP. When I tried, it didn't work. Maybe someone else knows...
Pete
Upvote
0
Smitty
Legend
- Joined
- May 15, 2003
- Messages
- 29,536
Welcome to the Board!
A formula won't change cell formats unless you're using Conditional Formatting. You'd need to use VBA. The most likely candidate would be the Find method to replicate your VLOOKUP, then either apply the format of the found value directly or Copy-->Paste Special-->Formats.
HTH,
A formula won't change cell formats unless you're using Conditional Formatting. You'd need to use VBA. The most likely candidate would be the Find method to replicate your VLOOKUP, then either apply the format of the found value directly or Copy-->Paste Special-->Formats.
HTH,
Upvote
0
