+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : Using LEFT,VLOOKUP and something?...

  1. #1
    Forum Contributor stojko89's Avatar
    Join Date
    05-18-2009
    Location
    Maribor, Slovenia
    MS-Off Ver
    MS Office 365
    Posts
    913

    Using LEFT,VLOOKUP and something?...

    Hello again.

    My problem is explaind in the attachment.
    Attached Files Attached Files

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Using LEFT,VLOOKUP and something?...

    Please post your question in the narrative - not the file... the file is to aid the narrative not the other way around.

  3. #3
    Forum Contributor stojko89's Avatar
    Join Date
    05-18-2009
    Location
    Maribor, Slovenia
    MS-Off Ver
    MS Office 365
    Posts
    913

    Re: Using LEFT,VLOOKUP and something?...

    Ok so my question is this:
    What I want is
    When I type a number like 900015 in colum N on sheet1 i want it to be copyed here like this.
    When i do that i want the info of row 2 to be copyed in row 2 in here
    I know I have to use the VLOOKUP fuktion fro colum B,C,D,E,F,G,H,I
    Now I'm using the formula for J that looks like this =IF(ISNUMBER(Tabela1[Nalog])="";"";LEFT(Tabela1[Nalog];7))
    So this copys the value from colum N from sheet1 into colum J on this sheet.
    My problem is this:

    If i type the number on sheet1 in row 2 it copys it in row 2
    If i type the number on sheet1 in row 3 it copys it in row 3
    But if i type the number on sheet1 in row 5 i want it to copy it to the next empty row so in this cas if row 2 and 3 are filled i want it to copy to row 4 now 5.

+ 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