Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Import Format Using Vlookup
I am creating a Graph using Cells containing vlookup which pulls out data
from another sheet. Depending on the kind of combo box I select in Graph, it can pull out data w.r.t. time or an average Function. Vlookup fetches data but not format. Is there anyways we can get the Format also from the source Data using Vlookup. |
#2
|
|||
|
|||
Sorry, but no.
If you want to pull formats, you need to use code. "SixString" wrote: I am creating a Graph using Cells containing vlookup which pulls out data from another sheet. Depending on the kind of combo box I select in Graph, it can pull out data w.r.t. time or an average Function. Vlookup fetches data but not format. Is there anyways we can get the Format also from the source Data using Vlookup. |
#3
|
|||
|
|||
Thanks for the Same, I have used a Macro using Cases for the results.
-- SixString "bj" wrote: Sorry, but no. If you want to pull formats, you need to use code. "SixString" wrote: I am creating a Graph using Cells containing vlookup which pulls out data from another sheet. Depending on the kind of combo box I select in Graph, it can pull out data w.r.t. time or an average Function. Vlookup fetches data but not format. Is there anyways we can get the Format also from the source Data using Vlookup. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I import XML as text format | Excel Discussion (Misc queries) | |||
Import format and then exporting | Excel Discussion (Misc queries) | |||
Format number as text on import | Excel Discussion (Misc queries) | |||
how to format numbers stored as text or vice versa to use vlookup | Excel Worksheet Functions | |||
Import Indian Rupees as a number format in Excel | Excel Discussion (Misc queries) |