+ Reply to Thread
Results 1 to 2 of 2

lookup with indirect

  1. #1
    Valued Forum Contributor
    Join Date
    04-21-2005
    Location
    Southern England
    MS-Off Ver
    Excel for Office 365
    Posts
    1,689

    lookup with indirect

    Hi,

    I require some help please with a lookup formula which includes indirect.

    I have a summary sheet and I would like the lookup to look at the sheet based on column C.

    I believe the formulas in columns E:H will be similar where it looks up the contract in column D of the summary sheet and matches this with column C of the different sheets.

    The trickier formula is column I. Here I need to return the total based on the contract name (column D) add in the word “Total” and then return the value in column X of the different sheets.

    I hope that makes sense.

    I have include an example. The yellow cells are where the formulas would go. I have included the expected results.

    Can anyone help please?
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    04-21-2005
    Location
    Southern England
    MS-Off Ver
    Excel for Office 365
    Posts
    1,689

    Re: lookup with indirect

    Hi

    Managed to do it with:
    =VLOOKUP(D6,(INDIRECT("'" & C6&"'!$c$5:$x$65000")),2,FALSE)
    and
    =VLOOKUP(D6&" Total",(INDIRECT("'" & C6&"'!$c$5:$x$65000")),22,FALSE)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] INDIRECT within a LOOKUP
    By strik009 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 01-09-2016, 06:44 AM
  2. Two Way Lookup With Indirect
    By pookyman in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-22-2015, 02:12 PM
  3. Lookup with an indirect
    By amartino44 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-06-2013, 01:01 PM
  4. [SOLVED] Lookup help using INDIRECT
    By Kuehl5000 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-20-2013, 05:24 PM
  5. Indirect + Lookup last value
    By slyzenoui in forum Excel General
    Replies: 2
    Last Post: 03-24-2007, 04:09 PM
  6. Lookup v Indirect
    By freekrill in forum Excel General
    Replies: 1
    Last Post: 09-26-2006, 01:45 PM
  7. [SOLVED] indirect lookup
    By choice in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-26-2005, 09:06 PM

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