Matching 2 cells and copying row contents.

**StevePike1990** · 10-12-2010, 12:09 PM

Ok here is my query,

I'm running keyword analysis's for client and this requires a search of ranks and search volumns, the problem is these come seperate, so I need a fomular that will link the 2.

So saying you have as an example

Sheet 1

A1 B1
Keyword Rank
Snowsuit 1

Sheet 2
A1 B1 C1
Keyword Competition Monthly Searches
SnowSuit 0.93 3600

I want these 2 to be combined into 1 to save me matching a few tousand keywords manually.

My result I would like is

Sheet 3
A1 B1 C1 D1
Keyword Rank Competition Monthly Searches
SnowSuit 1 0.93 3600

I need to this to run for each individual Keyword.

Is this possible?

**Cheeky Charlie** · 10-12-2010, 12:18 PM

try the Excel help for vlookup

hth

**StevePike1990** · 10-13-2010, 05:24 AM

Thanks will give it a go!

Steve

**StevePike1990** · 10-14-2010, 07:52 AM

Thanks for the sorted my problem out very well, I do however have another question.

What formula would I use to search my list and pull out all cells with say the word AUDI in? without duplicating each word over and over again? I heard you use matchup and offset?

Thanks

Steve Pike

**Cheeky Charlie** · 10-14-2010, 11:22 AM

if you'd like only to see words matching your criteria you would use a formula like =isnumber(find("audi"),A1)
which would evaluate to true if A1 contained the word audi
You could then copy this the length of your table and filter for audi

Please ask any more questions in new threads

hth