Forum Discussion
Solved
vlookup
I need to get vlookup to continue searching table rows, that contain my search value, until it finds a non-blank cell I am looking to return or the search value is no longer listed. My vlookup comman...
forsec0 VLOOKUP can't do that as it will only return the first match that it finds. And if that first one is a blank, you get 0. But since you are on MS365, try this:
=UNIQUE(FILTER(Sheet2!B:B,(Sheet2!A:A=$C3)*(Sheet2!B:B<>"")))
The following is a link to the actual spreadsheet: https://1drv.ms/x/s!AlwDxVSZhCUPb3Y69uRrNg7Dlvc?e=WRpPbK
forsec0 VLOOKUP can't do that as it will only return the first match that it finds. And if that first one is a blank, you get 0. But since you are on MS365, try this:
=UNIQUE(FILTER(Sheet2!B:B,(Sheet2!A:A=$C3)*(Sheet2!B:B<>"")))- It worked!!! Thank you very much. Going forward, I will explore unique and filter.