Results 1 to 7 of 7

Where to start?

Threaded View

  1. #1
    Registered User
    Join Date
    08-22-2012
    Location
    UK
    MS-Off Ver
    Excel 207
    Posts
    3

    Where to start?

    I need a cell to lookup if the text in another cell is in another cell in sheet 2, and then to input that data into the original cell

    Right so I have;

    Sheet 1-

    J2 - "carbon" (but this is ever changing)
    K2 - the cell i need the formula in.

    Sheet 2-

    A1 - "Carbon"
    A2 - "stick"
    B1 - "500"
    B2 - "100"


    I need a formula so a cell (K2, sheet 1, in this case) checks if the words "carbon" or "stick" (whichever are in cell J2, as these aren't the only two words, as the cell is always changing) are in the second work sheet in the 1st column, and if it finds, say, "carbon" then it will update itself (K2) to that of B1 in the second sheet (so if K2 finds the word carbon in the second sheet at A1, then it will update itself to the value of 500)


    I hope that isn't too confusing, I tried to explain the best I can.

    Thank you
    Last edited by Dailyb; 08-22-2012 at 09:34 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