Results 1 to 3 of 3

Match text in mulitple cells and display result

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-20-2010
    Location
    Pretoria, South Africa
    MS-Off Ver
    Excel 2016
    Posts
    151

    Match text in mulitple cells and display result

    I am new to the forum and hopefully I can explain myself in a way everyone can understand.

    Based on what I select in the drop down box of cells H2 and H3 (see attached sheet: TensionToGain.xls), I need cell F13 to show matching data from Cells E8:G:11.

    So every time I select a different option in the drop down box, cell F13 should show the matching values.

    I don't have an idea what formula to use. I have a look at VLOOKUP, MATCH, SEARCH, but with no avail.

    I also know that this would be a challenge for the guys on this forum, or NOT?
    Attached Files Attached Files
    Last edited by mrcois; 04-22-2010 at 02:08 AM.

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