Forum Discussion
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...
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