hi
how would i translate this simple formula into a lookup sub then saved as value not a formula
=XLOOKUP([@Participant],'Clients Info'!A:A,'Clients Info'!B:B)
this is very volotile
my workbook with many thousands of rows partcipant name change slightly in the database like added an initial or a lower case or space and most of my data already used and saved became #NA
i need the lookup as a formula but then saved as a value so it never changes no matter what happens - via VBA
please help me
how would i translate this simple formula into a lookup sub then saved as value not a formula
=XLOOKUP([@Participant],'Clients Info'!A:A,'Clients Info'!B:B)
this is very volotile
my workbook with many thousands of rows partcipant name change slightly in the database like added an initial or a lower case or space and most of my data already used and saved became #NA
i need the lookup as a formula but then saved as a value so it never changes no matter what happens - via VBA
please help me