Andy Wrote:
Hi,,,, solve my headache

I have 2 sheets within excel. i need a formula that will check the
names from 2 sheets, if it has the same name then it will enter into
sheet2 column G the contact number ( Sheet 1 - column C)

How the spread sheet is setup at the min!!
Sheet 1! In column A I have Surname - column B I have first name -
column C contact Number.
Sheet 2! In column A first name - column B surname.


TIA
Much appreciate any help

If you can make do by checking only first name or only surname ( you
cannot match both name and surname ) and then want to fill up the
contact number in Col G then you could try Vlookup. Suppose you want to
match surname. Let us assume that your table on sheet 1 has 20 rows of
data ( 1 to 20 ) then your lookup range is A1:C20. Also assume that
your table on sheet 2 starts from row 1 then formula for G1 would be
VLOOKUP(A1,sheet1!A1:C20,3). You can autofill this formula to all the
cells in G down below.

And yes one more pointer. Data in sheet 1 (A1:C20) should be sorted on
A1( Surname) in ascending order.

A V Veerkar


--
avveerkar
------------------------------------------------------------------------
avveerkar's Profile: http://www.excelforum.com/member.php...o&userid=30338
View this thread: http://www.excelforum.com/showthread...hreadid=506533