formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,"")
 
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
Click to expand...

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

These references will help you:
 
Back
Top