Results 1 to 4 of 4

VLookup issue using pivot table data

Threaded View

  1. #1
    Registered User
    Join Date
    02-13-2012
    Location
    Lakeland, FL
    MS-Off Ver
    Excel 2010
    Posts
    20

    VLookup issue using pivot table data

    I have this report I have been working on for a very long time and have made many changes over the past months to this report. It seems everytime I make changes I create more problems for myself. I am trying to eliminate some problems with improving formulas in the excel workbook. I am using 2010 and have never used the vlookup function. I will try to explain as clear as possible what I am trying to do.

    I have data in a pivot table called 'PivotTable2' has data in range A15:E28 (Column A has a month in it)
    I have a table in range G15:J28
    I have a control pivot table on a separate sheet called 'PivotTable4' has data in range A9:E22 (column A had a month in it that matches that of the PivotTable2)

    I have been using this formula '=IF(ISBLANK(B15),"",B15/Control!B9)'
    In this formula the Control part is the name of the sheet of the control pivot table.

    I need to take the above formula and convert it to using vlookup and have no clue how to go about doing this.
    Last edited by hsmith; 02-20-2012 at 04:55 PM.

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