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 command is: =VLOOKUP($C3,Sheet2!$A:$H,2,0). Cell D4 should contain A1:4E:88:E3:19:13
sheet1Tabsheet2Tab
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<>"")))
4 Replies
- 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<>"")))
