if a2 = b2 then insert d2 in e2
 

Hi,

I am trying to combine information in 2 different sheets. Sheet one has a
column with numbers and a column with titles. Sheet two has a column with the
same numbers and other information I would like to use. What I would like to
do is pull the title information from sheet 1 into sheet 2 based on the
unique numbers. Below the title to 3263 is superdog and I want to insert
superdog in the column next to 3263 on sheet 2.

Sheet 1 Sheet 2
A B A
1254 book 3263
3263 superdog 2456
2456 work for all 7754
--
Jake

if a2 = b2 then insert d2 in e2
 

=vlookup(a1,sheet1!a:b,2,false)

will return the value in column B for the first match between A1 and sheet1
column A.

Debra Dalgleish has lots of notes on =vlookup()
http://www.contextures.com/xlFunctions02.html
and
http://contextures.com/xlFunctions02.html#Trouble

Jake wrote:

Hi,

I am trying to combine information in 2 different sheets. Sheet one has a
column with numbers and a column with titles. Sheet two has a column with the
same numbers and other information I would like to use. What I would like to
do is pull the title information from sheet 1 into sheet 2 based on the
unique numbers. Below the title to 3263 is superdog and I want to insert
superdog in the column next to 3263 on sheet 2.

Sheet 1 Sheet 2
A B A
1254 book 3263
3263 superdog 2456
2456 work for all 7754
--
Jake

--

Dave Peterson