Results 1 to 2 of 2

Use code te get producto from a list

Threaded View

  1. #1
    Registered User
    Join Date
    05-27-2019
    Location
    Buenos Aires
    MS-Off Ver
    2007
    Posts
    4

    Question Use code te get producto from a list

    Hello, how are you guys doing.

    I´m having the next problem and i wanted to know if it is posible to solve it whit functions.

    Lets say in one page i have a list of productos and codes, example:

    180 blanco ALI-TW-78006
    260 blanco ALI-TW-78012
    330 blanco ALI-TW-78018
    tetina s ALI-TW-78019
    tetina m ALI-TW-78020
    tetina l ALI-TW-78021
    tetina + ALI-TW-78022
    container blanco ALI-TW-78028
    180 negro ALI-TW-78042
    260 negro ALI-TW-78043
    330 negro ALI-TW-78044

    And in other page i want to just write the codes and get on the next cell at the right the code based on the values on the first page table.

    Example if i write in the first page "180 blanco" i want the cell at the right to have a function that brings the product "ALI-TW-78006"

    Is that posible? how?

    Thanks.
    Last edited by Groximus; 05-27-2019 at 11:40 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. edit in code for populate range of cell in list box and code for delete any items
    By mazan2010 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-11-2017, 03:33 PM
  2. Big List Sort. Not Enough Memory. Help Run my Code. Or help fix or change code Please :)
    By Doc.AElstein in forum Excel Programming / VBA / Macros
    Replies: 47
    Last Post: 06-08-2017, 06:56 AM
  3. [SOLVED] System code change to price list code
    By makinmomb in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-05-2014, 11:49 PM
  4. [SOLVED] VBA Code to select each item in turn from a validation list and then run some other code
    By Kramxel in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-21-2014, 12:54 PM
  5. [SOLVED] code to open/close userform based on if a list box contains list items or not
    By Nitefox in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 01-11-2014, 06:23 PM
  6. Need to take my area code list, and make a state list.
    By Tommy1005 in forum Excel General
    Replies: 9
    Last Post: 07-29-2009, 03:55 AM

Tags for this Thread

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