Data from another worksheet

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Good Morning All,

Using Windows and Excel XP.

On sheet "A" I want to show data from sheets "B", "C" and "D". On
sheets B,C and D the data is in column A but changes rows everyday.
I know the formula on sheet "A" to show data on sheet "B" that is in a
fixed location, e.g. =B!A1. How would I set up the formula that would look
for the last row of data in column A on sheet "B".

Thanks for any help.

Michael
 
One way is to try and get a match on a number larger than would be possible
in your case
=match(999999999999,b!a:a)
then use that within an index function
=index(b!a:a,match(999999999999,b!a:a),1)
 
Thanks for the reply, but the data in sheet B, column A will vary as to high
and lows, so the data in the column is not always the lowest to the highest
or highest to lowest. I need to show the data that happens to be in the
last row at a given time.
Mike
 
So did you try it at all??

=INDEX(SheetB!A:A,MATCH(9.99999999999999E+307,SheetB!A:A))

This will do as you ask regardless of the order of the values in your list,
unless of course they equate to the number 9.99999999999999E+307
 
If match_type is 1 (by default), MATCH finds the largest value that is
less than or equal to lookup_value. Lookup_array must be placed in
ascending order: ...-2, -1, 0, 1, 2, ..., A-Z, FALSE, TRUE.

And there, the man said, the data ain't given in any particular order.

Is there any amicable concession rendered between the query and
solution ?

Regards.
 
Back
Top