Results 1 to 2 of 2

is it possible to contain 36 vlookups and an IF statement in a single cell?

Threaded View

  1. #1
    Registered User
    Join Date
    03-26-2013
    Location
    ireland
    MS-Off Ver
    Excel 2007
    Posts
    9

    Question is it possible to contain 36 vlookups and an IF statement in a single cell?

    I have a simple workbook with many sheets, on the first sheet i have a dice roller which gives me a 2 D6 (2-12) and a D66 (11-16,21-26 etc) value And i want to output my lookups to this sheet also.

    The D66 outputs to G12 and provides a Title from the second sheet titled D66
    =VLOOKUP(G12,'D66'!A1:B36,2)

    Now this title will be broken down by the 2D6 to a specific category each has its own sheet
    =IF(AND(G12=11),VLOOKUP(G11,'basic electronics'!A1:B12,2),0)

    now so far this works, but only if i get an 11 on the D66.

    How do i now incorporate the other 35 sheets?

    ive been drawing blanks all week and any help is much appreciated.
    Attached Files Attached Files
    Last edited by jaggeh; 04-03-2013 at 12:49 PM. Reason: solved

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