Results 1 to 3 of 3

Thread: urn data - trouble with Lookup function

  1. #1

    urn data - trouble with Lookup function



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello

    I have files that I have to turn like for example the file looks like that

    col1 col2 col3
    100 789 ckdsjfkd
    100 889 adsfdsf
    100 934 sjfkdsajf
    101 897 sdfdisjf
    101 394 sldfkdl


    and i need it to look like this (this is a fake data)

    col1 col2 col3 col4 col5 col6 col7
    100 789 ckdsjfkd 889 adsfdsf 934 sjfkdsajf
    101 897 sdfdisjf 394 sldfkdl


    I have used this formula

    =LOOKUP(REPT(“Z”,255),CHOOSE({1;2},"",INDEX($A$2:$A$20000,MATCH(TRUE,INDEX(ISNA(MATCH($A$2:$A$20000,$K$1:$K1,0)),0),0))))

    and then

    =IF(G2="","",IFERROR(INDEX($B$1:$F$3435,SMALL(INDEX(IF($A$2:$A$3435=$G2,ROW($A$2:$A$3435),""),,1),INT((COLUMNS($H:H)-1)/5)+1),MOD(COLUMNS($H:H)-1,5)+1),""))

    But now the lookup function is not working, is always says there is error in the formual. But it worked when I did this like 8 months ago:/

    Can you help me? If you have another idea to do this that works, I have been googling but can't find any

  2. #2

    More information

    I can see that the error is because excel whats me to use ; instead of , in the formula. Do not now why. If I change is just returns 0 in the colum

  3. #3
    Excel 2010 with free Power Query Add-In.
    Compatible with Office 2013 Pro Plus.
    No Lookup() or Match() formula, no VBA code.
    http://www.mediafire.com/view/8fmtvf.../02_01_15.xlsx

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •