Results 1 to 2 of 2

Thread: how to check list and write a value

  1. #1

    how to check list and write a value



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

    hi new in excel programing i have some kind of expirience in c# and i have a wery long list witch includes som numbers that i want to chech if its exist in the list and if it exsist i want to write another number beside the cell that number excist.

    hope some one could help me becouse its very har to do that in 200000 rows.

    e.

    123 132 *** asd
    111 111 456 wer match** write 456 from another list to cell beside the matching without any code in the cell.

  2. #2
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    675
    Articles
    0
    Excel Version
    Excel 2010 64bit
    Hello yusufugan

    You would get better advise if you were to provide a worksheet with a sample of the column you want to check and the list you want to check it against and the numbers that need to be written.

    A guess is:

    - a For Each loop on your list
    - an Application.Match against the column you want checked
    - and an offset or two to get and write the additional number

    I could be totally out to lunch with this guess, but there are many capable people that frequent the forum who are more likely to assist if they know exactly what you are working with rather than having to guess.

    Hope you can get some (better) suggestions

    NoS

Posting Permissions

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