Results 1 to 4 of 4

Find value within range and get it as result

Threaded View

Zaeguzah Find value within range and... 01-14-2011, 02:40 AM
DonkeyOte Re: Find value within range... 01-14-2011, 03:52 AM
JBeaucaire Re: Find value within range... 01-14-2011, 03:54 AM
Zaeguzah Re: Find value within range... 01-17-2011, 07:38 AM
  1. #1
    Forum Contributor
    Join Date
    07-16-2009
    Location
    NA
    MS-Off Ver
    MS Excel 2010
    Posts
    237

    Find value within range and get it as result

    Hi all

    I have the folowing layout

    J1 = "Nr. 8" K1 = "Bl. 44" L1 = "Sc. b" M1 = "Ap. 33"

    The above is not always in this order. I need a formula that will search the range J:M for a case insensitive string and return the found value as result.

    I tried the folosing but it doesn;t suit my needs
    =IF(FIND("Nr",J1,1),J1)
    Thank you
    Last edited by Zaeguzah; 01-17-2011 at 07:39 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