Hi Everybody !

I have 2 worksheets in an excel file which are constructed in the
following way :
Worksheet1 has 2 columns , A& B
Worksheet2 has 2 columns , C& D
A new column E needs to be created in Worksheet2 in such a way that the
value of a cell (e.g E2)is determined in the following way :

Search column B in Worksheet1 for the value D2 in Worksheet2 and where
the value is found (for e.g B7) , then E2=A7. If there is no value ,
return "No Names Found" .

Can this be done within a formula .

All help will be greatly appreciated !

Thanks.
-Girish Punjabi


--
Girish Punjabi
------------------------------------------------------------------------
Girish Punjabi's Profile: http://www.excelforum.com/member.php...o&userid=16048
View this thread: http://www.excelforum.com/showthread...hreadid=275087