+ Reply to Thread
Results 1 to 2 of 2

if function

Hybrid View

  1. #1
    Registered User
    Join Date
    03-21-2014
    Location
    beirut,lebanon
    MS-Off Ver
    Excel 2003
    Posts
    8

    if function

    i need the formula of
    in the sheet 1 if the cell f3 value is "zone1" than take the value of the cell of the sheet 2 a1 and if the cell f3 is" zone2" than take the value of the cell of the sheet 2 a2....
    i need to add 5 zone respectivly

    can you help me to get the right code
    thank you

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: if function

    Is it literally zone1 zone2 zone3, or were those simplified examples?

    If that was literal, then try

    =INDEX(Sheet2!A1:A5,RIGHT(F3,1)+0)

+ 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] IF Function referencing IsNumber, Match, Left function on separate sheets
    By Touch9713 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-12-2013, 10:09 PM
  2. [SOLVED] Using Offset function as the array in the PercentRank function is giving wrong result
    By Bobneil in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-06-2013, 09:29 PM
  3. Replies: 1
    Last Post: 03-21-2012, 11:22 AM
  4. Replies: 2
    Last Post: 03-20-2009, 01:29 PM
  5. [SOLVED] Excel - User Defined Function Error: This function takes no argume
    By BruceInCalgary in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-18-2006, 04:05 PM

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