+ Reply to Thread
Results 1 to 4 of 4

VBA lookup problem

  1. #1
    Registered User
    Join Date
    05-17-2020
    Location
    wirral
    MS-Off Ver
    365
    Posts
    4

    VBA lookup problem

    Hi, Im new to VBA so this may be a really simple question to answer!

    I am setting up a file that looks at the cell value which will be a range reference to a single cell. I then want to populate another cell on the same sheet with the variable cell range value from a different sheet.
    So, cell "sheet1 B2" has a value of "G44", I would like to look up G44 on sheet 2 and return whatever the value of "sheet 2 G44" is into "Sheet 1 C2"

    Hope this makes sense!?

    Thanks in advance.

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: VBA lookup problem

    Hi kelster1...

    Welcome to the forum...
    If B2 contains the reference to cell G44 then this will work...
    Please Login or Register  to view this content.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  3. #3
    Registered User
    Join Date
    05-17-2020
    Location
    wirral
    MS-Off Ver
    365
    Posts
    4

    Re: VBA lookup problem

    Thanks Sintek, worked like a charm :-)

  4. #4
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: VBA lookup problem

    Pleasure...tx for rep

+ 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. Lookup Problem
    By Eric Tsang in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-07-2016, 02:08 AM
  2. Lookup and sum problem
    By zaska in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 02-28-2014, 12:21 PM
  3. Lookup problem
    By gico1972 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-18-2013, 05:56 AM
  4. Lookup problem
    By LiamF in forum Excel General
    Replies: 1
    Last Post: 02-18-2011, 07:37 AM
  5. lookup problem
    By Tim Whitley in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-13-2006, 02:45 PM
  6. [SOLVED] LOOKUP problem!!!
    By G in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 PM
  7. LOOKUP problem!!!
    By G in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM

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