+ Reply to Thread
Results 1 to 3 of 3

To many IF's

  1. #1
    Registered User
    Join Date
    09-06-2007
    Posts
    7

    To many IF's

    Hello
    In my "data" page I have an A column with text strings consisting of 2 letters

    I have a page called "translation models" where the 2 letters can be find in the A column and a translation to the code in the B column.

    Page Data
    column A /column B
    CT / ?
    DB / ?
    CB / ?

    Page Translation models
    columnA / column B
    CT / 12345
    CB / 78910
    DB / 54321
    This list consist of more than 20 codes so far.
    I want to find a code for my B column ("data") that check the entire A column ("translation models) and returns the B value (translation models) to the B column (Data)

    I have tried this:

    =IF($A2='Translation Models'!$A$13;'Translation Models'!$B$13;IF($A2='Translation Models'!$A$14;'Translation Models'!$B$14;IF($A2='Translation Models'!$A$15;'Translation Models'!$B$15;IF($A2='Translation Models'!$A$16;'Translation Models'!$B$16;.....etc

    But it doesn't work when the list gets to long

    Any help would be appreciated

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,053

    Re: To many IF's

    Try write this in B2: =VLOOKUP(A2,'Translation Models'!$A$13:$B$15,2,FALSE)
    Never use Merged Cells in Excel

  3. #3
    Registered User
    Join Date
    09-06-2007
    Posts
    7

    Re: To many IF's

    Works perfect!!
    Thanks

+ Reply to Thread

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