+ Reply to Thread
Results 1 to 7 of 7

Import Format Using Vlookup

Hybrid View

  1. #1
    bj
    Guest

    RE: Import Format Using Vlookup

    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.


  2. #2
    SixString
    Guest

    RE: Import Format Using Vlookup

    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.


  3. #3
    SixString
    Guest

    RE: Import Format Using Vlookup

    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.


  4. #4
    SixString
    Guest

    RE: Import Format Using Vlookup

    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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1