Brianwarnock
Retired
- Local time
- Today, 17:59
- Joined
- Jun 2, 2003
- Messages
- 12,701
The row numbers have to change as the row changes, the colour in Qrow has to correspond to the code in Rrow.
As for matching the H rows that is what the Vlookup is doing or in the original case the Match
I don't want to appear rude but have you had a good look at the attachment.
Read Help on Vlookup, and Match and Offset while you are at it.
Look at the named ranges
I'm out of ideas to help.
Brian
As for matching the H rows that is what the Vlookup is doing or in the original case the Match
I don't want to appear rude but have you had a good look at the attachment.
Read Help on Vlookup, and Match and Offset while you are at it.
Look at the named ranges
I'm out of ideas to help.
Brian
