Forum Discussion
Merging data in spreadsheets
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...
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