+ Reply to Thread
Results 1 to 4 of 4

Comparing cell value to a table then extracting data from second table column

  1. #1
    Registered User
    Join Date
    02-04-2017
    Location
    Dayton, USA
    MS-Off Ver
    Excel 2010
    Posts
    10

    Question Comparing cell value to a table then extracting data from second table column

    Sorry if I don't use the proper terminology. I'm trying to create a BattleTech table...if anyone remembers that game. I have an "Engine Rating Value" on my front tab. On my second tab I have BattleTech's Fusion Engine Table which includes Engine Rating Values, manufacturers, and corresponding weights.

    What I need is for a cell (B7) on the front tab to compare the cell above it (B6) against column A of the table in tab 2, then for B7 to populate itself with the corresponding tonnage (column C of the table).

    Does this make any sense at all? Help!

    Thanks,
    Jared

    Tab 2
    Tab 1
    Attached Images Attached Images

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Comparing cell value to a table then extracting data from second table column

    =VLOOKUP(B6,'Sheet1'!$a$3:$c$10,3,false)

    Substitute Sheet1 with the name of the source sheet and adjust the ranges, as your Tab is clearly incomplete as it doesn't include 280 as a rating. failing that, do yourself (and the rest of us) a favour and attach a sheet, not a picture of one.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  3. #3
    Registered User
    Join Date
    02-04-2017
    Location
    Dayton, USA
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Comparing cell value to a table then extracting data from second table column

    That was it! Thank you SO MUCH. Next time I'll post the table itself. I may have another tricky question or two for you all before I'm done. -- Jared

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Comparing cell value to a table then extracting data from second table column

    You're welcome and thanks for the 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. Replies: 5
    Last Post: 01-28-2016, 01:43 PM
  2. [SOLVED] Extracting data from a column in a table to another table/sheet
    By hoowill12 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-02-2014, 05:47 PM
  3. Extracting and comparing information from pivot table.
    By jonboy6257 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-14-2014, 06:14 PM
  4. Extracting data from table for related table
    By ikavdiya in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 06-05-2013, 03:20 PM
  5. Extracting data from a table based on a common entries with another table
    By shannoncox in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-31-2012, 04:45 PM
  6. Comparing a Table with another data Table to replace with a Code
    By acsishere in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-28-2008, 01:26 PM
  7. Extracting Data from a Pivot Table and comparing
    By mwburne@yahoo.c in forum Excel General
    Replies: 1
    Last Post: 10-19-2007, 08:31 AM

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