Forum Discussion
Hilaire_Isley
Jan 08, 2021Copper Contributor
Excel Formula Combinations
Hi All I am in the process of performing a data mining project in an excel spreadsheet and versus continuing to copy and paste data from one trio of cells into another trio of cells, I am hoping for...
Riny_van_Eekelen
Jan 09, 2021Platinum Contributor
Hilaire_Isley Perhaps you mean something like in the attached workbook. Using VLOOKUP or the "new" XLOOKUP function, you can find a match between column E and A and then pick-up the information from B, C and D. Note that XLOOKUP may not (yet) be available for your Excel version.
You can read more about VLOOKUP in the link below. The article will also refer you to XLOOKUP.
https://support.microsoft.com/en-us/office/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1