Forum Discussion
how to use vlookup to list data in multiple columns of a different sheet
I'm trying to do the data storage and a clear data display in 2 sheets, in which it will work as example below: Sheet 1(details| revenue| outlay repeat about 20 times) invoice| details| revenue|...
If you have 365, this is the way to go:
=SUBSTITUTE(INDEX(FILTER(Master!C:BJ,Master!B:B=List!$B$1),1,SEQUENCE(20,3,1,1)),0,"")