Forum Discussion
Problem with LOOKUP formula
I have a simple LOOKUP formula which is =LOOKUP(B77,'Members List'!$A:$A,'Members List'!$B:$B) It is working in some cells, but not in others. Per attached - Cells C50 - C58 have exactly the same...
Try
=XLOOKUP(B77,'Members List'!$A:$A,'Members List'!$B:$B)
or
=VLOOKUP(B77,'Members List'!$A:$B,2,FALSE)