VLookUp needs helps

  • Thread starter Thread starter shoa
  • Start date Start date
S

shoa

Hello all

In a workbook, I have many worksheets. Each worksheet is a detail of a
person with ID and grade. These worksheets are called "Detail worksheet".
(for example, in a worksheet, cell A1 has 232 for ID and cell A3 has a grade
of 9. In another worksheet, cell A1 has ID is 321 and cell A3 has a grade of
4)

Also in that workbook, I have a separated worksheet with a list of people
with their IDs and empty grades. This worksheet is called "Sumary worksheet"

Now I want to input person's grade from each "Detail worksheet" for "Sumary
worksheet". Do you have a way to automantically insert grade from each
detail worksheet above to this "Sumary worksheet" so that I do not have to
input by hand. I do not know VLOOKUP can do this.

Thank you
S.Hoa
 
Hi
do you have the person ID or something else on your worksheet. Or how
do you identify which sheet belongs to which person?
 
I don't think =vlookup() is what you want.

If your grade is always in A3 of each of the detail worksheets, you could just
refer directly to that sheet.

The worksheets are named by ID???

if yes, if the id is in column B of the Summary worksheet:

=indirect("'" & b2 & "'!A3")

might do what you want.
 
Back
Top