Forum Discussion
oliviafox0
Mar 03, 2021Copper Contributor
merging on excel
Hi I really need assignment help. We have been given 2 charts, one which has a bunch of household numbers which define the house and the corresponding "city". the other has a bunch of individual statistics which correlate to houses through household numbers. How do I use excel to determine which household numbers belong to which city?
1 Reply
- cuong
Microsoft
Have you tried XLOOKUP? https://support.microsoft.com/en-us/office/xlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929