Forum Discussion
Solved
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 Worksh...
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!!!!