+ Reply to Thread
Results 1 to 4 of 4

=Sheet2!$B$ get number reference from another cell

  1. #1
    Registered User
    Join Date
    11-04-2021
    Location
    Oxford, England
    MS-Off Ver
    Professional Plus 2019
    Posts
    1

    =Sheet2!$B$ get number reference from another cell

    Hello!

    I have a list of about 2500 words that I need to pull into another sheet based on the word ID (please see sample sheet because it will make sense then). These words have been grouped into around 150 groups.

    I know I can type '=Sheet2!$B$' and then type the word ID is, but I would like to be able to drag and replicate the formula so that the row number it takes the word from in sheet 2 column B is dependent on the number in the cell to the right hand of where I am typing the formula.

    I've attached an example sheet so you can get clearer. I would really like to save myself from typing reference numbers all manually - please help! Thank you!
    Attached Files Attached Files
    Last edited by heybeckstar; 11-04-2021 at 12:12 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    10-19-2021
    Location
    Brazil
    MS-Off Ver
    Office 365 w/ Win7
    Posts
    562

    Re: =Sheet2!$B$ get number reference from another cell

    Possible solution.

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,487

    Re: =Sheet2!$B$ get number reference from another cell

    I think that you mean:

    B4:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

  4. #4
    Valued Forum Contributor
    Join Date
    10-19-2021
    Location
    Brazil
    MS-Off Ver
    Office 365 w/ Win7
    Posts
    562

    Re: =Sheet2!$B$ get number reference from another cell

    Could also be:
    B4:

    Formula: copy to clipboard
    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. VBA to identify existing use of a reference number then locate next reference number?
    By Miskondukt in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-05-2017, 04:36 PM
  2. Column number reference using cell reference
    By Fatrobo in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-16-2015, 12:50 AM
  3. how to reference cell value from column number and row number
    By jed38 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-11-2015, 07:37 PM
  4. Copy Rows with "Closed" in Cell to the bottom of the existing data in Sheet5
    By Baxterma in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-07-2014, 10:30 AM
  5. [SOLVED] Delete Sheets Until Sheet5
    By HerryMarkowitz in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-20-2013, 05:55 AM
  6. [SOLVED] VBA Code to copy all data from sheet 1 and paste it to sheet5 using a command button
    By Angnz in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-10-2013, 10:06 PM
  7. How can you open a tab(Sheet5) by clicking on particular cell say.
    By Suren Suthar in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-20-2005, 07:06 PM

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