Forum Discussion
BBaker90
Jan 18, 2022Copper Contributor
Xlookup
Good morning,
I have a multi-sheet spreadsheet. I want the table on one sheet to autofill the sections on another sheet based off what is put into one cell. I can get vlookup to work on 2 specific columns. Xlookup looks like it should do exactly as I want, however I cannot get it to work at all. I even tried doing the formula on the same sheet as the table I am using. Here are photos showing the formulas (highlighted: vlookup on top, xlookup on bottom) and one showing the results.
HTS Category would be the value placed in another cell and looked up in the table. I want it to fill in HTS Code and Country of Origin in other cells based on HTS Category. I can get HTS Code to fill with vlookup.
5 Replies
- SergeiBaklanDiamond Contributor
- BBaker90Copper ContributorIt works! Thanks so much. I followed the instructions I found, which covered multiple columns in the lookup array so I would have never thought of that.
- SergeiBaklanDiamond Contributor
BBaker90 , you are welcome