Forum Discussion
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 ...
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.