I am new to Excel and having trouble getting the following to work, hopefully someone will be able to point me in the right direction to get this going, it would be very much appreciated!
On sheet one, I would like to have the Computer Serial Number cells (Column D) on Sheet one (below), check against another column on Sheet 2 (bottom Image)...
If the Serial Number is matched on Column B of Sheet 2, I am trying to get Excel to grab the corosponding Asset Tag on Sheet 2 (Column A) and populate the Column G cell on Sheet 1.
I am just unable to figure this out, and would really appreciate some help if someone has a few minutes to take a look or at minimum point me in the right direction. Thank you!
On sheet one, I would like to have the Computer Serial Number cells (Column D) on Sheet one (below), check against another column on Sheet 2 (bottom Image)...
If the Serial Number is matched on Column B of Sheet 2, I am trying to get Excel to grab the corosponding Asset Tag on Sheet 2 (Column A) and populate the Column G cell on Sheet 1.
I am just unable to figure this out, and would really appreciate some help if someone has a few minutes to take a look or at minimum point me in the right direction. Thank you!