VLOOKUP macro needs Offset
Posted by School Marm on June 08, 2001 2:13 PM
Here is my situation: I'm putting together an attendance sheet and have named a sheet for each teacher. When I come to the sheet named "Attendance" the third column is the resultant number of a bar code scan. Each scan has a matching code in a table on that page, i.e., 123445 = Present.
My formula is coming from the teacher's page [Sheets(shName).Activate] and seeks to execute the following:
ActiveCell = "=VLOOKUP(myLookup,Legend,2,FALSE)"
This all works fine execpt the ActiveCell is in Row 3 and the first reference in myLookup is in Row 2. I have been looking diligently for documentation on VLOOKUP and Visual Basic but can find little. Can anyone help?
Thanks in advance!