Results 1 to 9 of 9

Thread: Need some help
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    May 2019
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Need some help

    Hi!

    I need help with my excel worksheet.

    If I write XXXX in column A - YYYY will appear in column b.
    Is that possible?

  2. #2
    Board Regular
    Join Date
    Oct 2014
    Location
    UK
    Posts
    3,826
    Post Thanks / Like
    Mentioned
    16 Post(s)
    Tagged
    3 Thread(s)

    Default Re: Need some help

    put =if(A1="XXXX","YYYY","") in B1 and copy down
    Last edited by AlanY; May 29th, 2019 at 03:04 AM.

  3. #3
    New Member
    Join Date
    May 2019
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Need some help

    Quote Originally Posted by AlanY View Post
    put =if(A1="XXXX","YYYY","") in B1 and copy down

    Hmm, sorry that won't work.

    We have 17 workorder number which is connected to 17 PO numbers.

    (WO 1901 - PO 0101
    1902 - 0102
    1903 - 0103 etc etc)

    So if I write WO number "1901" in column A - PO Number "0101" will be written in column b. Would save alot of time!

  4. #4
    Board Regular
    Join Date
    Oct 2014
    Location
    UK
    Posts
    3,826
    Post Thanks / Like
    Mentioned
    16 Post(s)
    Tagged
    3 Thread(s)

    Default Re: Need some help

    ok, try vlookup() with a table like this

    ABCDE
    119050105WOPO
    219010101
    319020102
    419030103
    519040104
    619050105
    719060106
    819070107
    919080108
    1019090109
    1119100110
    1219110111
    1319120112
    1419130113
    1519140114
    1619150115
    1719160116
    1819170117

    Sheet1



    Worksheet Formulas
    CellFormula
    B1=VLOOKUP(A1,$D$2:$E$18,2,FALSE)


  5. #5
    Board Regular
    Join Date
    Oct 2014
    Location
    UK
    Posts
    3,826
    Post Thanks / Like
    Mentioned
    16 Post(s)
    Tagged
    3 Thread(s)

    Default Re: Need some help

    or just ="01"&RIGHT(A1,2) in B1 might work

  6. #6
    New Member
    Join Date
    May 2019
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Need some help

    Quote Originally Posted by AlanY View Post
    ok, try vlookup() with a table like this

    A B C D E
    1 1905 0105 WO PO
    2 1901 0101
    3 1902 0102
    4 1903 0103
    5 1904 0104
    6 1905 0105
    7 1906 0106
    8 1907 0107
    9 1908 0108
    10 1909 0109
    11 1910 0110
    12 1911 0111
    13 1912 0112
    14 1913 0113
    15 1914 0114
    16 1915 0115
    17 1916 0116
    18 1917 0117
    Sheet1

    Worksheet Formulas
    Cell Formula
    B1 =VLOOKUP(A1,$D$2:$E$18,2,FALSE)
    Thank you, this did the work.
    Is it possible to extend the script to lookup from another sheet? Im creating new WO with unique number that is also connected to PO numbers.

    Example: WO: 19301 - 0107
    19409 - 0117

  7. #7
    New Member
    Join Date
    May 2019
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Need some help

    Couldn't delete my previous post, but here's an better explanation. I hope

  8. #8
    New Member
    Join Date
    May 2019
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Need some help


  9. #9
    Board Regular
    Join Date
    Oct 2014
    Location
    UK
    Posts
    3,826
    Post Thanks / Like
    Mentioned
    16 Post(s)
    Tagged
    3 Thread(s)

    Default Re: Need some help

    in that case, its better to define the table as range then it can be put anywhere in the wookbook.

    table now defined as =Sheet4!$A$1:$B$18

    AB
    119050105
    219170117

    Sheet1



    Worksheet Formulas
    CellFormula
    B1=VLOOKUP(A1,Table,2,FALSE)

    Workbook Defined Names
    NameRefers To
    Table=Sheet4!$A$1:$B$18



    AB
    1WOPO
    219010101
    319020102
    419030103
    519040104
    619050105
    719060106
    819070107
    919080108
    1019090109
    1119100110
    1219110111
    1319120112
    1419130113
    1519140114
    1619150115
    1719160116
    1819170117

    Sheet4




Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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