Results 1 to 3 of 3

Lookup

Threaded View

  1. #1
    Registered User
    Join Date
    10-29-2009
    Location
    California
    MS-Off Ver
    Excel 2003 & 2008 for Mac
    Posts
    2

    Lookup

    I am trying to update a spreadsheet based on the values in the attached table. I am new to the more involved formula's on Excel, and my brain is fried trying all the different possibilities. None seem to be doing what I need which is to select the value based on the column and row header (as identified in my spreadsheet that I am updating).

    For example, the item to update will have a step of 4, and item is R3. the value should be 30.48.

    How can I format the formula so that both the column and row are variables in selecting the value?

    Any help is greatly appreciated.

    Thanks,
    Paul
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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