santeria
Well-known Member
- Joined
- Oct 7, 2003
- Messages
- 1,844
I am not sure if Vlookup is the ideal way of doing this, but...
I am trying to set up a Vlookup to match on the basis of two criteria... A group ( 1,2,3,4,5), and a Week ( 1,2,3,4).
The Group Number and the week number will obviously be in different columns, but even if I have to change the Week designation to a letter, thats fine, so long as I can get a lookup for group and date.
I can do a vlookup for a staff member based on number, but the row will pull extra data as well ,related to the person, but the key search is by Group number and by Date week.
Any Suggestions or references appreciated, I can't seem to find anything applicable in the archives.
Ta
I am trying to set up a Vlookup to match on the basis of two criteria... A group ( 1,2,3,4,5), and a Week ( 1,2,3,4).
The Group Number and the week number will obviously be in different columns, but even if I have to change the Week designation to a letter, thats fine, so long as I can get a lookup for group and date.
I can do a vlookup for a staff member based on number, but the row will pull extra data as well ,related to the person, but the key search is by Group number and by Date week.
Any Suggestions or references appreciated, I can't seem to find anything applicable in the archives.
Ta