Forum Discussion

BBaker90's avatar
BBaker90
Copper Contributor
Jan 18, 2022
Solved

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

    • BBaker90's avatar
      BBaker90
      Copper Contributor
      It 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.

Resources