Forum Discussion
Excel - compare value, input another value
I am excel challenged and only do a basic vlookups.
I have a large spreadsheet, with two worksheets I want to compare and then get data from one and put on the other.
Worksheet 1 - users
Worksheet 2 - lastlogon
I am trying to, lookup Workbook 1- Column A, see if it is in Workbook 2 - Column A, easy, BUT if found, then I want it to pull Workbook 2 Column C and put it in Workbook 1 - Column H.
Help!
In H2 on Worksheet 1:
=XLOOKUP(A2, 'Worksheet 2'!$A:$A, 'Worksheet 2'!$C:$C, "")
Replace Worksheet 2 with the actual name of the second sheet.
Fill down.
In H2 on Worksheet 1:
=XLOOKUP(A2, 'Worksheet 2'!$A:$A, 'Worksheet 2'!$C:$C, "")
Replace Worksheet 2 with the actual name of the second sheet.
Fill down.
@HansVogelaar _ THANK YOU SO VERY MUCH!!!!
