I HAVE TWO FILES, IN ONE FILE I HAVE TWO ROWS & IN THE OTHER FILE I HAVE ONE
ROW IF THE VALUE IN THE ROW NO:1, OF THE SECOND FILE IS EQUAL TO THE VALUE IN
THE FIRST FILE THE THEN THE TEXT IN THE SECOND ROW OF THE FIRST FILE IS TO
BE DISPLAYED IN THE SECOND FILE SECOND ROW

read this and repost
http://www.mvps.org/dmcritchie/excel/getstarted.htm


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"KORAH" wrote in message
...
I HAVE TWO FILES, IN ONE FILE I HAVE TWO ROWS & IN THE OTHER FILE I HAVE
ONE
ROW IF THE VALUE IN THE ROW NO:1, OF THE SECOND FILE IS EQUAL TO THE VALUE
IN
THE FIRST FILE THE THEN THE TEXT IN THE SECOND ROW OF THE FIRST FILE IS
TO
BE DISPLAYED IN THE SECOND FILE SECOND ROW

How many columns do you have? If you're looking for a match over several
columns then try HLOOKUP otherwise try this formula in A2 sheet2

=IF(A1=sheet1!A1,sheet1!A2,"")

"Don Guillett" wrote:

read this and repost
http://www.mvps.org/dmcritchie/excel/getstarted.htm


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"KORAH" wrote in message
...
I HAVE TWO FILES, IN ONE FILE I HAVE TWO ROWS & IN THE OTHER FILE I HAVE
ONE
ROW IF THE VALUE IN THE ROW NO:1, OF THE SECOND FILE IS EQUAL TO THE VALUE
IN
THE FIRST FILE THE THEN THE TEXT IN THE SECOND ROW OF THE FIRST FILE IS
TO
BE DISPLAYED IN THE SECOND FILE SECOND ROW

Sun, 22 Jul 2007 05:10:01 -0700 from KORAH
:
I HAVE TWO FILES, IN ONE FILE I HAVE TWO ROWS & IN THE OTHER FILE I HAVE ONE
ROW IF THE VALUE IN THE ROW NO:1, OF THE SECOND FILE IS EQUAL TO THE VALUE IN
THE FIRST FILE THE THEN THE TEXT IN THE SECOND ROW OF THE FIRST FILE IS TO
BE DISPLAYED IN THE SECOND FILE SECOND ROW

Please don't shout, and please do explain more clearly what it is you
want to do.

These references will help you:
http://dts-l.org/goodpost.htm
http://groups.google.com/group/micro...e6df24a245a0ca

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/