Two-way lookup
http://j-walk.com/ss/excel/usertips/tip020.htm

Thorough solution:
http://www.cpearson.com/excel/TablesAndLookups.aspx

Simple solution:
http://www.contextures.com/xlFunctio...ml#IndexMatch2

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Sh" wrote in message
...
I have data in Worksheet A, Column A & B that I want to match with data
from
Worksheet B, Column A & B to return a value from Worksheet B, Column C to
Worksheet A Column C. If there are no matches found where Column A & B
match
in both worksheets, I want the data from Worksheet A, Column A to be the
value of Worksheet A, Cloumn C. Is this possible?