How to automatically check for early identical entries?

1. How to automatically check for early identical entries?

Cheers everyone,

I am doing a translation and I am using Excel. There are two columns in my worksheet. Column A with the original text and column B with the translation. Every once in a while I run into a word I have translated before.

Is there anyway I could have excel checking if the value of cell A (x) is equal to a value A (1-x) (eg. A8) if so then fill cell B (x) with the corresponding value (eg. of the cell B8).

Perhaps it is a simple conditional formating but I can't figure out the formula.

Thank you.

D

2. Re: How to automatically check for early identical entries?

If you are making hard coded inputs in column B, then if you have a formula in B, the hard-coding will wipe out the formula.... if it is one-time deal, then it shouldn't matter.

You can start column B, cell B2, with formula like:

=IF(A2="","",IF(ISNUMBER(MATCH(A2,A\$1:A1,0)),VLOOKUP(A2,A\$1:B1,2,0),""))

assuming you are starting in Row 2.

Then copy down as far as you want.

Now as you enter items in column A, if a translation already appeared above, then it should show up... if it doesn't show, then overwrite the formula.

When it is all done, you can copy column B and paste special over itself, selecting Values option so that all formulas are gone. (optional)

Would that work?

See N's post

4. Re: How to automatically check for early identical entries?

Hi NBVC

Apparently there is an error in the formula, I can not test it. Would it be possible for you to send me the formula in an excel sheet/cell?

Thanks a lot.

D

5. Re: How to automatically check for early identical entries?

Try this version:

=IF(A2="";"";IF(ISNUMBER(MATCH(A2;A\$1:A1;0));VLOOKUP(A2;A\$1:B1;2;0);""))

your regional settings probably uses semi-colons instead of commas as argument separators

6. Re: How to automatically check for early identical entries?

Yep it is working.

Thanks a lot.

Cheers

D

Great...

8. Re: How to automatically check for early identical entries?

Originally Posted by NBVC
Great...

Super. Thank you again.

Bests

Dorian

9. Re: How to automatically check for early identical entries?

How to mark a thread Solved
Go to the first post
Click edit
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

10. Re: How to automatically check for early identical entries?

Done.

Takes a little time to learn 'where is what'.

thanks

D

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