Lookup variabel field in variabel sheet
On Jan 4, 12:29 am, Ken Johnson wrote:
On Jan 3, 11:53 pm, Robert wrote:
What exactly do you mean with 9.99E+307?
You can assume that DIVIDENDS RECEIVED always lies within the range
J1:J100
Robert
I assumed that DIVIDENDS RECEIVED would be the bottom-most entry in
column J.
The likelihood that the actual value of DIVIDENDS RECEIVED would be
equal to or greater than 9.99E+307 is essentially zero, otherwise you
are working for the richest person in the universe! (9.99E+307 is the
largest number that excel can deal with) .
So, when the MATCH function goes looking for the row in column J
containing 9.99E+307 it doesn't find it and it returns instead the
number of elements in the range. With the range set at J:J, MATCH
returns the row containing DIVIDENDS RECEIVED, but only if DIVIDENDS
RECEIVED is the bottom-most entry in column J.
Is DIVIDENDS RECEIVED the bottom-most column J entry on your sheets?
Ken Johnson
Oops! RECEIVABLE, not RECEIVED
Ken Johnson
|