Forum Discussion

Thomas_H_two's avatar
Thomas_H_two
Copper Contributor
Oct 25, 2023

Is this possible?!

I want to enter a Name into the TEST Table on Sheet 1 and have it auto-populate the Location, based on the Location Table on Sheet 2.f Is there a way to match the name to the Location Table and pull the data in yellow to show on sheet 1's box in yellow?

Is this possible?

Appreciate any help!

 

 

excel
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Oct 25, 2023

    Thomas_H_two If you are on E365 or 2021 use XLOOKUP like this:

    =XLOOKUP(C10,Sheet2!B5:B10,Sheet2!D5:D10,"not found")

     

    If you are using an older version use VLOOKUP:

    =IFERROR(VLOOKUP(C10,Sheet2!B5:D10,3,FALSE),"not found")

     Adjust the ranges referring to rows 5 through 10 in Sheet2 to ones that suit your real location data. Or better to put the Location data in a structured table. Then you can reference the columns in the table by their names without having to worry where the table is located. So, not sheet names to be included in the references.

Resources