1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excel, matching data in rows

Discussion in 'Business Applications' started by translator_83, Feb 22, 2013.

Thread Status:
Not open for further replies.
  1. translator_83

    translator_83 Thread Starter

    Joined:
    Feb 22, 2013
    Messages:
    1
    Not sure where to post this; hope I found the right forum.

    I have a set of texts in the source language in Excel. I have translated these into the target language. What I now want to do is match the source language data with my translations.

    Is there any way to tell Excel that "when the text XXX is in column G, row 341, the text XXX is to be inserted into column H, row 341)?

    Just an example.

    In other words, what I want to do is make sure my translations are placed in the column to the right of each source language text.

    Regards
    Mattias
     
  2. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    64,891
    First Name:
    Wayne
    i have moved to business applications

    in column H you can use IF

    in H341
    =IF(G341="XXX", G341, "what to do if not")

    this will copy G341 into H341 only if G341 contains "XXX"

    OR
    =IF(G341="XXX", "YYY", "what to do if not")

    if what you want inserted is different text
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1090588

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice