Excel Formula Combinations

%3CLINGO-SUB%20id%3D%22lingo-sub-2044588%22%20slang%3D%22en-US%22%3EExcel%20Formula%20Combinations%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2044588%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%3C%2FP%3E%3CP%3EI%20am%20in%20the%20process%20of%20performing%20a%20data%20mining%20project%20in%20an%20excel%20spreadsheet%20and%20versus%20continuing%20to%20copy%20and%20paste%20data%20from%20one%20trio%20of%20cells%20into%20another%20trio%20of%20cells%2C%20I%20am%20hoping%20for%20the%20right%20formula%20that%20would%20replicate%20the%20data%20inputs%2C%20where%20applicable.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENote%2C%20the%20data%20is%20sorted%20properly%20and%20fills%20up%208%20columns%20in%20total%20and.%20Because%20the%20data%20in%20each%20cell%2Frow%20do%20not%20necessarily%20mirror%20one%20another%2C%20that%20does%20not%20mean%20that%20its%20match%20does%20not%20appear%20in%20another%20row%20(maybe%20up%20or%20down%20the%20sheet)%20and%20so%20a%20simple%20%3D()%20formula%20is%20not%20ideal.%20I%20am%20trying%20to%20alleviate%20the%20copy%20and%20paste%20method%20and%20am%20hoping%20for%20a%20formula%20that%20can%20be%20used%20which%20will%20auto%20populate%20the%20data%20in%20a%20new%20cell%2C%20whenever%20there%20is%20a%20match%2C%20possibly%20an%20IF(AND)%20statement%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20are%20the%20column%20headers%3C%2FP%3E%3CP%3EABCD%20and%20EFGH%20each%20have%26nbsp%3BName%20Tel%2C%20Email%2C%20DOB%20within%20its%20cells%3C%2FP%3E%3CP%3EI%20enter%20my%20data%20into%20cells%20BCD%20and%20need%20the%20data%20to%20appear%20in%20FGH%20also%2C%20when%20A%20and%20E%20match.%3C%2FP%3E%3CP%3EIs%20this%20possible%3F%20thanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2044588%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2045186%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20Combinations%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2045186%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F922739%22%20target%3D%22_blank%22%3E%40Hilaire_Isley%3C%2FA%3E%26nbsp%3BPerhaps%20you%20mean%20something%20like%20in%20the%20attached%20workbook.%20Using%20VLOOKUP%20or%20the%20%22new%22%20XLOOKUP%20function%2C%20you%20can%20find%20a%20match%20between%20column%20E%20and%20A%20and%20then%20pick-up%20the%20information%20from%20B%2C%20C%20and%20D.%20Note%20that%20XLOOKUP%20may%20not%20(yet)%20be%20available%20for%20your%20Excel%20version.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20read%20more%20about%20VLOOKUP%20in%20the%20link%20below.%20%26nbsp%3BThe%20article%20will%20also%20refer%20you%20to%20XLOOKUP.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fvlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fvlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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 the right formula that would replicate the data inputs, where applicable.

 

Note, the data is sorted properly and fills up 8 columns in total and. Because the data in each cell/row do not necessarily mirror one another, that does not mean that its match does not appear in another row (maybe up or down the sheet) and so a simple =() formula is not ideal. I am trying to alleviate the copy and paste method and am hoping for a formula that can be used which will auto populate the data in a new cell, whenever there is a match, possibly an IF(AND) statement

 

Here are the column headers

ABCD and EFGH each have Name Tel, Email, DOB within its cells

I enter my data into cells BCD and need the data to appear in FGH also, when A and E match.

Is this possible? thanks

 

 

1 Reply

@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