Merging data in spreadsheets

%3CLINGO-SUB%20id%3D%22lingo-sub-3113881%22%20slang%3D%22en-US%22%3EMerging%20data%20in%20spreadsheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3113881%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20two%20spreadsheets.%20Spreadsheet%20one%20has%20Customer%20Numbers%20and%20Spreadsheet%20two%20has%20Customer%20Numbers%20and%20the%20state%20the%20customer%20is%20in.%26nbsp%3B%3C%2FP%3E%3CP%3EWithin%20spreadsheet%20one%2C%20I%20need%20to%20figure%20out%20how%20to%20create%20a%20column%20that%20says%2C%20if%20the%20customer%20numbers%20match%2C%20insert%20the%20corresponding%20state%20from%20spreadsheet%20two.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20If%20then%20or%20something%20else%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3113881%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3113915%22%20slang%3D%22en-US%22%3ERe%3A%20Merging%20data%20in%20spreadsheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3113915%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1296673%22%20target%3D%22_blank%22%3E%40derrickgirard%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DVLOOKUP(A2%2C'Customer%20numbers%20and%20state'!%24A%242%3A%24B%2425%2C2%2CFALSE)%3C%2FP%3E%3CP%3E%3DINDEX('Customer%20numbers%20and%20state'!%24B%242%3A%24B%2425%2CMATCH('Customer%20numbers'!A2%2C'Customer%20numbers%20and%20state'!%24A%242%3A%24A%2425%2C0))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMaybe%20with%20these%20formula%20as%20shown%20in%20the%20attached%20file.%20If%20you%20work%20with%20Office365%20or%202021%20you%20can%20apply%20XLOOKUP%20as%20well.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3113921%22%20slang%3D%22en-US%22%3ERe%3A%20Merging%20data%20in%20spreadsheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3113921%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1296673%22%20target%3D%22_blank%22%3E%40derrickgirard%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20more%20of%20%26nbsp%3Ba%20lookup%20function.%20Here%20is%20a%20link%20to%20a%20website%20that%20shows%20the%20%22how-to%22%20of%20VLOOKUP%2C%20which%2C%20based%20on%20your%20description%2C%20is%20probably%20what%20you%20need.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fexceljet.net%2Fexcel-functions%2Fexcel-vlookup-function%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexceljet.net%2Fexcel-functions%2Fexcel-vlookup-function%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3117933%22%20slang%3D%22en-US%22%3ERe%3A%20Merging%20data%20in%20spreadsheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3117933%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1174419%22%20target%3D%22_blank%22%3E%40Quadruple_Pawn%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20the%20help...i%20am%20tying%20to%20do%20this%20so%20it%20pulls%20in%20ranges...is%20it%20possible%20to%20send%20you%20the%20spreadsheet%20so%20you%20can%20see%3F%20I%20can't%20see%20how%20to%20attach%20something%20to%20this%20reply.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have two spreadsheets. Spreadsheet one has Customer Numbers and Spreadsheet two has Customer Numbers and the state the customer is in. 

Within spreadsheet one, I need to figure out how to create a column that says, if the customer numbers match, insert the corresponding state from spreadsheet two. 

 

Is this If then or something else?

5 Replies

@derrickgirard 

=VLOOKUP(A2,'Customer numbers and state'!$A$2:$B$25,2,FALSE)

=INDEX('Customer numbers and state'!$B$2:$B$25,MATCH('Customer numbers'!A2,'Customer numbers and state'!$A$2:$A$25,0))

 

Maybe with these formula as shown in the attached file. If you work with Office365 or 2021 you can apply XLOOKUP as well.

@derrickgirard 

 

It's more of  a lookup function. Here is a link to a website that shows the "how-to" of VLOOKUP, which, based on your description, is probably what you need.

https://exceljet.net/excel-functions/excel-vlookup-function

 

@Quadruple_Pawn 

 

Thanks for the help...i am tying to do this so it pulls in ranges...is it possible to send you the spreadsheet so you can see? I can't see how to attach something to this reply.

@derrickgirard 

=VLOOKUP($A2,'Customer numbers and state'!$A$2:$D$25,COLUMN(B1),FALSE)

 

Maybe you want to pull ranges with above formula.

 

When i select "reply" -> "open full text editor" i then can select "drap and drop or browse a file" as shown in the attached file. Does this work for you as well?

The option to drag and drop or browse does not show up for me.