Forum Discussion
VLOOKUP References to tables with new columns
Hello, I have a question about shifting vlookup references when adding new columns to the referenced table. Ex: I have a master data table with all my data I have a few different tabs with vloo...
cgaechter Try this:
=VLOOKUP([@[ProjectUiD]],DataFULL!A:AF,COLUMNS(DataFULL!A:AF),0)