+ Reply to Thread
Results 1 to 5 of 5

Lookup Info on another sheet

  1. #1
    Registered User
    Join Date
    04-30-2021
    Location
    New Mexico, United States
    MS-Off Ver
    Office 365
    Posts
    6

    Lookup Info on another sheet

    Okay one more time! I'm trying to pull a percentage from another sheet for specific cities. So if the city on my sheet one is Rio Rancho (Cell F5) then we would go to sheet two find Rio Rancho and then pull the percentage from the column next to the column that say Rio Rancho. I am currently using this formula: =VLOOKUP(F5,'GRT Table'!$A$1:$B$268,2,1)*F9 but it is not working correctly. The cities are listed in columm A and the percentages are listed in B.

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,361

    Re: Lookup Info on another sheet

    There are instructions at the top of the page explaining how to attach your sample workbook

  3. #3
    Registered User
    Join Date
    04-30-2021
    Location
    New Mexico, United States
    MS-Off Ver
    Office 365
    Posts
    6

    Re: Lookup Info on another sheet

    I am speaking of the fields F10 & F12 on sheet Seller's Netout.
    Attached Files Attached Files
    Last edited by regina85345; 08-20-2021 at 02:58 PM.

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,361

    Re: Lookup Info on another sheet

    Your example of "Rio Rancho" had a trailing blank in "GRT table" hence no match. A common error!

  5. #5
    Registered User
    Join Date
    04-30-2021
    Location
    New Mexico, United States
    MS-Off Ver
    Office 365
    Posts
    6

    Re: Lookup Info on another sheet

    I figured out my problem and it is working now. Thank you so much for your assistance!

+ 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. Auto update info in Sheet 1 based on a find/lookup in Sheet 2.
    By compustrat in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-15-2019, 10:05 AM
  2. Button takes info from Sheet 1, transcribes to Sheet 2, info deletes on Sheet 1
    By LNT225 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-02-2016, 04:54 PM
  3. Replies: 3
    Last Post: 04-12-2015, 04:01 PM
  4. Replies: 1
    Last Post: 04-11-2015, 02:16 AM
  5. Excel 2007 : Help with formula on lookup info or matching info
    By Jerry Ellerbee in forum Excel General
    Replies: 4
    Last Post: 04-06-2011, 01:20 PM
  6. lookup cell info and returning line info
    By Wisconsinscw in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-08-2008, 07:05 PM
  7. Replies: 6
    Last Post: 06-21-2006, 12:40 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