R
Robin Reid
Worksheet 1 and 2 have student ID numbers in column 1 to identify the
records. I am trying to use the ID number to look up information in worksheet
2 and have it placed in a specific cell in worksheet 1. If the ID number is
not contained in worksheet 2 I would like the function to remain blank or to
place the number zero in the cell. If the ID number is located in worksheet 2
then I want the function to return the value in the corresponding column 2.
records. I am trying to use the ID number to look up information in worksheet
2 and have it placed in a specific cell in worksheet 1. If the ID number is
not contained in worksheet 2 I would like the function to remain blank or to
place the number zero in the cell. If the ID number is located in worksheet 2
then I want the function to return the value in the corresponding column 2.