+ Reply to Thread
Results 1 to 3 of 3

If cell equals certain criteria, vlookup on selected sheet

  1. #1
    Registered User
    Join Date
    02-05-2015
    Location
    Karratha, Australia
    MS-Off Ver
    2010
    Posts
    15

    Cool If cell equals certain criteria, vlookup on selected sheet

    Hi all,

    I need a formula which will vlookup a certain sheet depending on what the criteria equals.. For example;

    (see attached spreadsheet)

    If Cell A of Sheet1 equals "1152" vlookup cell E of Sheet1 in cell A of 1152 sheet and return cell C of 1152 sheet in highlighted cell H of Sheet1 (where I need the formula) however if cell A of Sheet1 equals "1169", vlookup cell E of Sheet1 in cell A of 1169 sheet and return cell C of 1169 sheet in highlighted cell H of Sheet1.

    Hope that makes sense..!

    Thanks in advance
    Attached Files Attached Files

  2. #2
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: If cell equals certain criteria, vlookup on selected sheet

    Enter in H2 and copy down
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  3. #3
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: If cell equals certain criteria, vlookup on selected sheet

    hi there. if you have more worksheets, try:
    =VLOOKUP(E2,INDIRECT("'"&A2&"'!A:C"),3,0)

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

+ 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] Cell Value equals sheet name..Help Please
    By biznez in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-20-2016, 03:58 PM
  2. [SOLVED] Need help. If A:2 equals anything in A:A in another sheet, need value of a different cell.
    By excel_newser in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-06-2014, 12:12 PM
  3. Textbox value equals value of selected cell
    By cameron213 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-02-2014, 06:33 PM
  4. Create a number sequence and restart when a cell value equals a criteria
    By manian in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-15-2013, 02:46 AM
  5. [SOLVED] VLOOKUP help aka if user chooses cell a1, then b1 equals x - Noob Alert
    By sidewaysscott in forum Excel General
    Replies: 5
    Last Post: 07-19-2012, 05:25 PM
  6. Cell A1 Equals Sheet name
    By JoshF in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-21-2011, 08:10 AM
  7. Cell Value Equals sheet Name
    By Vetequk in forum Excel General
    Replies: 1
    Last Post: 05-14-2009, 03:32 AM

Tags for this Thread

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