Forum Discussion
EmmaLiuLiu
Helper I
Helper ILookupvalue not look up all rows!
Hi,
What's the possible cause that makes lookupvalue not look up all qualified rows? I copied and pasted down the values so they are defitinely the same. However, lookupvalue left a few blanks. So confusing! I know vlookup in excel only picks the first row. Lookupvalue has something similar like that?
1 Reply
- MNedix
Solution Sage
Heya,
The behavios is definitely peculiar so can you provide a snippet of your data after removing any confidential info?
