Automatically Cross-Referencing data

**Monkihunta** · 02-10-2013, 06:46 AM

Hi,

I'm a bit of a noob, so I'm not sure if I've posted this in the right place, but maybe someone here can help me with this query.

Let's say I have an excel file (we'll call it File A) with a list of Japanese terms in column A. I want to fill in column B with the English equivalent. In another Excel file (File B), I have a big database with all the Japanese terms that I'd need listed side by side with their English equivalents in columns. So, if I was going to fill in column B in File A, I could simply copy and search the term in column A in File B, then copy the data into File A. But, if I have thousands of terms in column A, I'd really like to find a way to automate it if possible. Does anyone know how to do that? Please ask if I didn't explain very well.

Thanks a lot!

**oeldere** · 02-10-2013, 06:58 AM

you have 1 file with in column A japanese name and in column B the English name?

Then you want those names in an second workbook with only japanese names in column A.

If so, you can use Vlookup for that.

e.g.
=Vlookup(a1,sheet2!a1:b1500;2,0)

explaination

Lookup the value in a1.

Find that value (from a1) in the range sheet2!a1:b1500

Find the 2nd value (is the english name)

Find an exact math (1 is the other option).

In this case I used Vlookup within a workbook (namely the 2nd sheet).

You can also look up in another workbook.

You have to put the directory in the reference.

It's easier to have both files open, than you can refer to the other workbook.

In that case the name will be automatic filled in the formula.

Automatically Cross-Referencing data

LinkBack

Thread Tools

Rate This Thread

Display

Automatically Cross-Referencing data

Re: Automatically Cross-Referencing data

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions