Forum Discussion
Move data from one excel sheet to another sheet
I new to excel and have the following data in my excel workbook. WORKSHEET 1 (complete data table): (A) – First Name (B) – Last Name (C) – Email Address (D) – Unique Identifier ...
=XLOOKUP(C2,Worksheet1!$C$2:$C$13,Worksheet1!$D$2:$D$13,"")
You can apply XLOOKUP for this evaluation for example. The ranges of XLOOKUP can easily be adapted to the size of your data e.g. :
=XLOOKUP(C2,Worksheet1!$C$2:$C$1000,Worksheet1!$D$2:$D$1000,"")
- Thank you, for replying.
I finally received results with VLOOKUP, will look into XLOOKUP.
Again thank you.
