Forum Discussion
Solved
xlookup with multiple criteria including partial text match
hi need help in extracting values in cell S10, im getting H6=1657 but i should be getting H4=1569 how should the xlookup function be fixed?
your other conditions (G:G=R10) use the whole column as reference, so try adjusting LEFT(D4:D31) to LEFT(D:D,1)
The ranges don't have the same size.