I
it
Here is the list I am using from worksheet 1 (named
"charges")...partial list...worksheet is 400 rows long
COLUMN C COLUMN D
22.942777778 18
22.993611111 19
23.054166667 20
23.149444444 21
....
13.403611111 262
13.469722222 263
13.534722222 263
13.687500000 263
Here is the list I am using from worksheet 2
COLUMN B COLUMN C
23:00 19
23:05
I'm using this formula from worksheet 2 in column C
=VLOOKUP((B28-0)*24,Charges!C640,2)
Everything works fine when I use the above formula...but when I expand
the query set to D400 (because there may be up to 400 rows of data) it
always returns the last cell (263) with data.
Any idea why it returns the last row? Is there a max in the range?
Any help is very much appreciated.
-BD
"charges")...partial list...worksheet is 400 rows long
COLUMN C COLUMN D
22.942777778 18
22.993611111 19
23.054166667 20
23.149444444 21
....
13.403611111 262
13.469722222 263
13.534722222 263
13.687500000 263
Here is the list I am using from worksheet 2
COLUMN B COLUMN C
23:00 19
23:05
I'm using this formula from worksheet 2 in column C
=VLOOKUP((B28-0)*24,Charges!C640,2)
Everything works fine when I use the above formula...but when I expand
the query set to D400 (because there may be up to 400 rows of data) it
always returns the last cell (263) with data.
Any idea why it returns the last row? Is there a max in the range?
Any help is very much appreciated.
-BD