Forum Discussion
Solved
Integrating subset of Excel workbook with original workbook
I searched prior posts and have not found a solution to my issue but if someone can help or direct me to other help I appreciate it. I have two Excel workbooks, one with over 3000 rows (I'll call it...
- What you need is the XLOOKUP function. Open both workbooks next to each other.
- On an empty cell next to your data, type =XLOOKUP(
- Point at the cell in column A on the same row, you should now have something like =XLOOKUP(A2
- press the comma on your keyboard
- Now select the cells in column A of the other workbook. Your formula will look like this:
=XLOOKUP(A2,[Book1]Sheet1!$A$2:$A$3500
- press the comma again and point to the cells from which you need to pull information.
- press enter
your formula should look similar to this:
=XLOOKUP(A2,[Book1]Sheet1!$A$2:$A$3500,[Book1]Sheet1!$D$2:$D$3500)
What you need is the XLOOKUP function. Open both workbooks next to each other.
- On an empty cell next to your data, type =XLOOKUP(
- Point at the cell in column A on the same row, you should now have something like =XLOOKUP(A2
- press the comma on your keyboard
- Now select the cells in column A of the other workbook. Your formula will look like this:
=XLOOKUP(A2,[Book1]Sheet1!$A$2:$A$3500
- press the comma again and point to the cells from which you need to pull information.
- press enter
your formula should look similar to this:
=XLOOKUP(A2,[Book1]Sheet1!$A$2:$A$3500,[Book1]Sheet1!$D$2:$D$3500)
- On an empty cell next to your data, type =XLOOKUP(
- Point at the cell in column A on the same row, you should now have something like =XLOOKUP(A2
- press the comma on your keyboard
- Now select the cells in column A of the other workbook. Your formula will look like this:
=XLOOKUP(A2,[Book1]Sheet1!$A$2:$A$3500
- press the comma again and point to the cells from which you need to pull information.
- press enter
your formula should look similar to this:
=XLOOKUP(A2,[Book1]Sheet1!$A$2:$A$3500,[Book1]Sheet1!$D$2:$D$3500)
Thanks so much; this is great. I forgot to copy it down the row the first time, and walked away from this for a few hours. Then I thought about how Excel works and realized my error. After that this was quick and simple. I also looked at a little more information about XLOOKUP and found I could return a custom value for no match if I wanted to go to the trouble to do so. But I can sort on the #N/A values easily enough and categorize the other variables of interest for the selected cases. Thanks again for your help!