+ Reply to Thread
Results 1 to 4 of 4

Lookup and return adjacent cells value

  1. #1
    Registered User
    Join Date
    02-29-2012
    Location
    usa
    MS-Off Ver
    Excel 2010
    Posts
    8

    Lookup and return adjacent cells value

    I have one sheet named sub bids with 10 colums for differnt bids next to the bid price is the company name. I have a sheet called estimate that looks up the smallest number in the row and returns that value. I would like for the cell next to it to return the company name next to that coresponding number. Thanks for any help

  2. #2
    Valued Forum Contributor
    Join Date
    04-03-2012
    Location
    East Sussex, UK
    MS-Off Ver
    Excel 2003:2010
    Posts
    893

    Re: Lookup and return adjacent cells value

    Hi,

    Without seeing an example workbook it's hard to say. But perhaps =OFFSET() would be what you're looking for here?
    If I've been of help, please hit the star

  3. #3
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Lookup and return adjacent cells value

    Try the Vlookup function or using INDEX & MATCH functions. A sample worksheet will help.
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  4. #4
    Registered User
    Join Date
    02-29-2012
    Location
    usa
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Lookup and return adjacent cells value

    thanks for the response here is the sheet, the value is in the estimate sheet and in the column marked subcontractor I would like it to look up the value and insert the contractor name. Example look up e26 value on sub bid c19:M19 and return the coresponding name in pre estimate cell G26
    Attached Files Attached Files

+ 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