Results 1 to 8 of 8

Thread: help

  1. #1
    Join Date
    Jan 2004
    Posts
    17

    Unanswered: help

    hi
    i have a code for each row of data in one sheet , but i dont know how to, when i go on to a different sheet, link it up so that when i type in that code that row that it corrisponds to will be copied and pasted to where i want it to be.

  2. #2
    Join Date
    Dec 2003
    Location
    San Diego, CA
    Posts
    153
    Just a thought, but have you looked at VLOOKUP in the help file?

    Smitty

  3. #3
    Join Date
    Jan 2004
    Posts
    17
    yes thanx but i still wouldnt know wot i would be writing in. i will add the attatchment so you see wot i mean
    Attached Files Attached Files

  4. #4
    Join Date
    Dec 2003
    Location
    San Diego, CA
    Posts
    153
    See the VLOOKUPS that I added.

    Smitty
    Attached Files Attached Files

  5. #5
    Join Date
    Jan 2004
    Posts
    17
    thanx but this isnt what i quite wanted. i wanted to type the code in the table and the description, size, price, and qty would appear
    Last edited by ben2001; 01-28-04 at 18:16.

  6. #6
    Join Date
    Dec 2003
    Location
    San Diego, CA
    Posts
    153
    That's what happens with what I posted.

    Try deleting the code and see what happens. Then type the code back in.

    If you want to get around the #N/A error message, adjust the formulas as so:

    =IF(ISNA(VLOOKUP(Lookup Range, Source Range, Column Index, FALSE)),"",VLOOKUP(Lookup Range, Source Range, Column Index, FALSE))

    Smitty

  7. #7
    Join Date
    Jan 2004
    Posts
    17
    this is it
    Attached Files Attached Files

  8. #8
    Join Date
    Dec 2003
    Location
    San Diego, CA
    Posts
    153
    Here you go.

    Note comments in Blue.

    Smitty
    Attached Files Attached Files

Posting Permissions

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