+ Reply to Thread
Results 1 to 8 of 8

match and return another cell value

  1. #1
    Forum Contributor
    Join Date
    03-18-2008
    Posts
    162

    match and return another cell value

    Hi Guys,

    I am struggling to get a result from matching a cell. I have attached an example as it is hard to explain. I want to display the result in Column H, so I need a calculation to find the value in cell F5 within column B and display the value in D if found. Column F can change value though. so my first result in cell H5 would display 0020 - D D H Double Hanging Robe.

    I hope I have explained it ok.

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: match and return another cell value

    Try:

    =VLOOKUP(F5,$B$5:$D$27,3,FALSE)

    copied down.

    adjust ranges to suit actual data
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Forum Contributor
    Join Date
    03-18-2008
    Posts
    162

    Re: match and return another cell value

    Hi And thanks,

    That works in my example but in my spreadsheet it wont work, I believe its because I have extracted column F from a row of text using this formula:

    =MID(A24;SEARCH("[";A24)+1;1000)

    As it was like so "Product[0020]item"

    So do I have to convert this to number or can I edit the formula.

    Thanks

  4. #4
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: match and return another cell value

    Can you post a sample that more closely reflects your actual spreadsheet?

  5. #5
    Forum Contributor
    Join Date
    03-18-2008
    Posts
    162

    Re: match and return another cell value

    Ok column L is where I want the information to be displayed, I want to find column K in column E and dislpay the value from in G

    Thanks
    Attached Files Attached Files

  6. #6
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: match and return another cell value

    Your values in column E are numbers with formatting to add the leading zeros, whereas your values in column K are text strings with lead zeroes attached.... must be the same...so try:

    =VLOOKUP(K8+0,$E$8:$H$268,3,FALSE)

    which converts column K to number before trying to match to column E

  7. #7
    Forum Contributor
    Join Date
    03-18-2008
    Posts
    162

    Re: match and return another cell value

    That works great thanks.

  8. #8
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: match and return another cell value

    If you look at the formula in the column next to the one you put Vlookup in... you will notice the Match() function also used this concept of K8+0....

+ 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