+ Reply to Thread
Results 1 to 2 of 2

Help comparing two cells with a table

  1. #1
    Registered User
    Join Date
    07-24-2012
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    20

    Question Help comparing two cells with a table

    I have two cells (I4), one with age (R4) and the other with a dollar amount for life insurance policy amount. The table (AG3:AR13) that needs to be compared to. The age comparison is column AG4:AG13 and the amount comparison is row A3:AR3. The cost is in between as show in the below image:
    Untitled-1.jpg

    How can I match the age and amount to the cost?

    Thanks,

    Clint

  2. #2
    Valued Forum Contributor
    Join Date
    09-10-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    929

    Re: Help comparing two cells with a table

    Hi Clint,

    Try this formula... =VLOOKUP(I4,$AG$4:$AH$13,2)*R4/1000

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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