Results 1 to 6 of 6

If A = B then display C in D

Threaded View

  1. #1
    Registered User
    Join Date
    01-23-2014
    Location
    Amsterdam
    MS-Off Ver
    Excel 2013
    Posts
    3

    If A = B then display C in D

    Hi guys!

    Hoping for a (quick) salvation! I'm a total excel noob (I can do basic stuff) but I need to get something done here.

    http://puu.sh/6vkIl.png

    I want Excel to do the following:

    If H8 matches A8 then display B8 (text) in G8.
    Consequently: If H8 does not match A8 but A9, display B9 in G8
    Consequently if H8 does not match A9 but A10, display B10 in G8
    Etcetra

    I can't do it with a simple 'if' statement as show in the screenshot (http://puu.sh/6vkV0.png). Probably because an IF statement can only display numbers and not text (?)

    Been googling a solution for hours, and I didn't really get anything I could comprehend and copy over.

    Oh and a screenshot of the full sheet: http://puu.sh/6vl6q.png

    (And for those curious. This is just some excel practice with making rosters, team rotations and other things. Using a 'fireteam' composition of a fictional marine corps.)
    Last edited by daniellange; 01-23-2014 at 01:23 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 01-05-2014, 06:19 PM
  2. Find and display the last occurance in two columns and display related cell
    By willia97 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-28-2012, 08:14 PM
  3. Replies: 2
    Last Post: 06-19-2012, 07:48 AM
  4. Replies: 0
    Last Post: 05-15-2012, 10:04 PM
  5. Can I display an Excel chart as my screensaver display?
    By Burke in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-01-2006, 02:05 PM

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