+ Reply to Thread
Results 1 to 3 of 3

Look up a value in another sheet

  1. #1
    Registered User
    Join Date
    09-11-2020
    Location
    Edmonton, Alberta, Canada
    MS-Off Ver
    2020
    Posts
    6

    Exclamation Look up a value in another sheet

    I need to know what the*VLOOKUP FORMULA*is for moving numbers between these 2 sheets because I can not figure out the formula myself. I have tried all day, and I can not get it.

    I have 2 sheets named "Testing Day 1" and "Month 1 Week 1". I want to pull the number in cell Q12 from "Testing Day 1" and then drop that number into the cell B97 in "Month 1 Week 1".


    I know I need to enter a*VLOOKUP FORMULA*(or another formula that does the same thing)*into the cell B97 in Month 1 Week 1. But I don't know exactly how to enter all the variables in the formula to make it work. I do know the formula needs to look something like this though.


    =VLOOKUP(Q12, Testing Day 1!$B$97, 14, FALSE)


    I want to do the exact same thing in the screenshot below too. Pull the number from cell Q12 in Testing Day 1 and drop that number into cell C11 in Master File using a VLOOKUP FORMULA again*(or another formula that does the same thing).
 I also have screenshots to share with you if that would help.

    JUST PLEASE TELL ME HOW TO ENTER THIS FORMULA PROPERLY?? IT IS DRIVING ME COMPLETELY INSANE??
    Last edited by 6StringJazzer; 09-16-2020 at 06:40 PM.
    Alexander Bouraad

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    16,663

    Re: HELP ME!!! Can Not Get Formula To Work??

    Your screen shots were not attached correctly.

    I would suggest attaching your actual file. See yellow banner at the top of the page.

    Your sample VLOOKUP formula is wrong. Please look up the Excel help for VLOOKUP. The second argument needs to be a range, not a single cell.

    Also your title needs work. I tweaked it a bit because you are still a new user but please give thought to titles.

  3. #3
    Registered User
    Join Date
    09-11-2020
    Location
    Edmonton, Alberta, Canada
    MS-Off Ver
    2020
    Posts
    6

    Re: HELP ME!!! Can Not Get Formula To Work??

    I've tried countless times to attach screenshots on here. They never attach. EVER. I upload the image and nothing ever happens. It just sits there doing nothing. It never processes the image or saves it or anything. So I just gave up trying to attach screenshots on here.

+ 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. Replies: 2
    Last Post: 01-31-2018, 08:49 AM
  2. [SOLVED] Need a COUNTIF formula to work with Excel 2000. Not confident it will work?
    By g1terra in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-06-2017, 01:59 AM
  3. [SOLVED] Work Planner with formula for work rotations
    By sorensjp in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-12-2017, 09:24 PM
  4. [SOLVED] Formula in one work sheet wont accept result from another in a different work sheet.
    By Belinea2010 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 08-07-2015, 12:24 PM
  5. Replies: 0
    Last Post: 11-12-2012, 04:49 AM
  6. Trying to work formula for work TIME SHEET using IF formula
    By help_monique in forum Excel General
    Replies: 8
    Last Post: 10-12-2009, 11:46 PM
  7. [SOLVED] A search for $ in a formula use to work now it does not work
    By JuneJuly in forum Excel General
    Replies: 2
    Last Post: 11-30-2005, 06:15 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