+ Reply to Thread
Results 1 to 2 of 2

find value from another sheet and the corresponding column values

  1. #1
    Registered User
    Join Date
    11-29-2020
    Location
    india
    MS-Off Ver
    2000
    Posts
    55

    find value from another sheet and the corresponding column values

    i am trying to get the values from another sheet based on eventtype passed into the function.

    so it shud find the eventtype and the get the values in corresponding columns into AA,BB,CC ad finally output them into Result, but i get error at eventCellAddress saying invalid qualifier

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    1,958

    Re: find value from another sheet and the corresponding column values

    This is not a function, this code has no function construct ...
    Maybe something like a'la that ?
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Find and Replace Multiple Columns in Sheet 1 Based on a Column Values in Sheet 2
    By adblog3 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-07-2020, 01:49 PM
  2. VBA to find unique values in one sheet that have no related values in another sheet
    By theDavidErickson in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-05-2016, 05:13 PM
  3. Replies: 6
    Last Post: 07-26-2015, 03:43 AM
  4. [SOLVED] Find Values in Column A and fill identical values in Column B
    By deviltronics in forum Excel General
    Replies: 6
    Last Post: 10-07-2014, 05:25 PM
  5. Replies: 2
    Last Post: 12-30-2013, 08:15 AM
  6. Replies: 2
    Last Post: 10-08-2012, 02:17 PM
  7. Macro that will copy values in Column J and paste values to Column B in new sheet
    By Phixtit in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-16-2010, 04:56 PM

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