+ Reply to Thread
Results 1 to 3 of 3

Possible 'IF' Formula

  1. 05-22-2014, 09:09 AM #1
    omletto
    omletto is offline
    Forum Contributor
    Join Date
    04-14-2009
    Location
    Wales
    MS-Off Ver
    Excel 2010
    Posts
    129

    Possible 'IF' Formula

    Hi all,

    Please take a look at the attached spreadsheet. I am looking for a formula to put in row EN. All I want is for it to put the bin location of the component. eg in cell EN5 I'd like it to show 'J4B' and EN6 'L1B' etc.

    Any help would be appreciated.

    R's

    Om
    Attached Files Attached Files
    Last edited by omletto; 05-22-2014 at 11:11 AM.
    Reply With QuoteRegister To Reply
  2. 05-22-2014, 09:44 AM #2
    kvsrinivasamurthy
    kvsrinivasamurthy is offline
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,587

    Re: Possible 'IF' Formula

    Pl see attached file.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 05-22-2014, 11:10 AM #3
    omletto
    omletto is offline
    Forum Contributor
    Join Date
    04-14-2009
    Location
    Wales
    MS-Off Ver
    Excel 2010
    Posts
    129

    Re: Possible 'IF' Formula

    That is fantastic. Thank you very much for your assistance.

    Kind regards,

    Om
    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. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1