Pulling data from one spreadsheet if its matche din another

**finnjav** · 07-23-2012, 04:19 PM

Hi here's my issue:

Spreadsheet 1: List of 500 companies

Spreadsheet 2: List of 1200 companies in one column, with revenue in another.

Problem: I want to see if any of the companies in spreadsheet 1 are matched in the list in spreadsheet 2, and if they are then I want to insert the corresponding revenue from spreadsheet 2 next to the company name in spread sheet 1.

Any ideas?

**oeldere** · 07-23-2012, 04:34 PM

You posted no excel example.

So i just give you a hint.

Use index / match.

Having said that.

I recognise this question. You already posted this one today.

Please mark one question as solved.

**finnjav** · 07-23-2012, 05:01 PM

Here is the example.

That first sheet is the companies I want to look up, the second is the master list that has all the revenues/employee sizes. Book1.xlsx

**Hang Glider** · 07-23-2012, 05:13 PM

vlookup is another option.

someone may be able to explain index/match, but I use vlookup so much I find it very easy.

essentially:

=vlookup(value to look up, place to look it up including all data desired [array], column number, 'false' to force exact match)

so
=vlookup(a2,other spreadsheet a2:f502,4,false)
this assumes a2:f502 covers the data you're looking for, and that the data you want is in column 4.

you do not need to bring over more than you need - if it's only columns a & b, that's fine
but...
the leftmost column of the array MUST contain the data you're matching on. It looks to the right for column 4, not to the left.

Now that I see your example, you may have to clean up to get exact matches...