+ Reply to Thread
Results 1 to 5 of 5

Put value in its proper place

  1. 11-19-2014, 09:20 AM #1
    YasserKhalil
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Put value in its proper place

    Hello
    I have values in range("F3:F6")
    In range ("A3:A6") I have these strings:

    EGP
    EUR
    USD
    GBP

    In Range ("B2:E2") I have the same strings:
    EGP USD EUR GBP

    I want to put my values in range ("F3:F6") in its proper place
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 11-19-2014, 09:30 AM #2
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Put value in its proper place

    Does this help?

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 11-19-2014, 09:45 AM #3
    YasserKhalil
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Put value in its proper place

    Great Mr. JOHN H. DAVIS
    Thank you very much
    Can it be done by formulas?
    Reply With QuoteRegister To Reply
  4. 11-19-2014, 10:33 AM #4
    romperstomper
    romperstomper is offline
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Put value in its proper place

    In B3:

    =IF(B$2=$A3,INDEX($F$3:$F$6,MATCH(B$2,$A$3:$A$6,0)),"")

    and fill across/down.
    Remember what the dormouse said
    Feed your head
    Reply With QuoteRegister To Reply
  5. 11-19-2014, 12:13 PM #5
    YasserKhalil
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Put value in its proper place

    Perfect Mr. romperstomper
    Thank you very much for your perfect solutions..
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Deciding on 1st place 2nd place etc for a TOP 10 List
    By Brentsa in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-09-2014, 09:54 PM
  2. How to make a graph start at the proper place?
    By Adrian20XX in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-10-2009, 05:55 AM
  3. automaticly place the person in 1st, 2nd, 3rd etc. place according to the result of t
    By sync in forum Excel General
    Replies: 2
    Last Post: 06-24-2007, 10:16 AM
  4. Big sheet..neeed to jump from place to place
    By RHagerty in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-12-2007, 07:48 AM
  5. [SOLVED] Is this the proper place to ask my question?
    By amkazen in forum Excel General
    Replies: 1
    Last Post: 03-01-2006, 01:25 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1