Forum Discussion
Using XLookup or related formulas to look up information on one sheet and put in a column on another
I have lists of students alphabetically by grade level. From another system, I get lists of all students, past and present, alphabetically by their library #. I need to be able to take the barcode fr...
Here is an example. I just usually get NA. I have tried using xlookup nested within, vlookup, etc. But it never seems to work. Riny_van_Eekelen
ABirdLibrary The problem is what you are feeding the XLOOKUP() function. Here is the formula you want in the example:
=XLOOKUP(C2:C6,'student library #'!C:C,'student library #'!D:D)The "lookup_value" is the value you are using to match the corresponding row in the other table. In this case it is Student Name. I used C2:C6 to create a dynamic array that will automatically fill down for all those rows but you could use C2 and then copy or fill down to insert the corresponding formula in each row.
I hope that helps.
Thank you so much! That really did help,mtarler