MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Finding the next value in a range...


Posted by A Wright on January 31, 2000 8:04 PM

Is there a function that will tell Excel to look for the next value in a given range?
Something like "B1+1" = B2, rather than the value of "B1" + 1.

I have non-contiguous cells looking at a contiguous range and have to enter each reference...

Thanks.


Posted by Celia on February 03, 2000 3:58 PM


I am not clear about what you need to do.
Can you provide more details or an actual example?
Celia

Posted by A Wright on February 03, 2000 8:14 PM

One sheet has the report format, the next sheet the data.

The data is simply a table exported from my Claims system,
The report format is multiple rows, with all the table data
arranged so it is easily read. All the data cells get their
data using a VLOOKUP on the data page, with the reference being
a single claim number....

If cel A3 has "=Data!A3" to get the appropriate number, when I
copy down to the next section, I want to see "=Data!A4" rather than
"=Data!A10" because I skipped 7 rows. Once the claim number is found,
the rest of the report fills in.

Posted by A Wright on February 03, 2000 8:15 PM

One sheet has the report format, the next sheet the data.

The data is simply a table exported from my Claims system,
The report format is multiple rows, with all the table data
arranged so it is easily read. The data cells get their
data using a VLOOKUP on the data page, with the reference being
a single claim number....located in the upper left most cel of the
section.

If cel A3 has "=Data!A3" to get the appropriate number, when I
copy down to the next section, I want to see "=Data!A4" rather than
"=Data!A10" because I skipped 7 rows. Once the claim number is found,
the rest of the report fills in.

Posted by A Wright on February 03, 2000 8:15 PM

One sheet has the report format, the next sheet the data.

The data is simply a table exported from my Claims system,
The report format is multiple rows, with all the table data
arranged so it is easily read. The report cells get their
data using a VLOOKUP on the data page, with the reference being
a single claim number....located in the upper left most cel of the
section.

If cel A3 has "=Data!A3" to get the appropriate number, when I
copy down to the next section, I want to see "=Data!A4" rather than
"=Data!A10" because I skipped 7 rows. Once the claim number is found,
the rest of the report fills in.

Posted by Celia on February 03, 2000 10:27 PM


Sorry, I don't know a quick solution (I would need to develop a custom made macro).
Perhaps someone else can help.
Celia