Hi All
Using VLOOKUP and it's great. However, I would like to also copy over the looked-up cell's COLOR in addition to just the number there.
What would i need to add to this formula?
=IFERROR(VLOOKUP(a2, statsjan2010!$A$1:$C$11740, 2, FALSE), "0")
Thanks!
You would need to use VBA - unless the format required can be determined by the actual value resulting from the formula (ie result of VLOOKUP is 2, 2 means "red" etc...) ... if that is the case you can use Conditional Formatting based on the result.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks