Results 1 to 4 of 4

Doublecheck with second lookup starting starting after first match

Threaded View

  1. #4
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: Doublecheck with second lookup starting starting after first match

    Hello again
    Sorry, I didn't realize that you wanted to do this with VBA. The workbook I attached only had an array formula on the 'Data' sheet in cell O3. You enter your search values in cells M3 and N3 and the booking message is returned in O3. Having now looked at your code, I think you perhaps know more VBA than I do. I'm not sure how to get array formulas to run in VBA. The only way that I might do it, is to link the form to the Data sheet formula. I think you'll have to search for both date and company to find a match, if I understand your problem correctly. Perhaps another user can help?
    Last edited by DBY; 10-06-2011 at 12:30 PM. Reason: Amended reply

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