KidCudi
07-19-2021, 05:59 AM
Hi All,
I would like to get your expert advise on how to get around this issue I am encountering.
I am trying to populate a cells so that it will lookup the value from row while skipping blank cells within that row and displaying those values in a column.
So whenever a lookup value is populated on C3, it will lookup DataSheet sheet from Column B to O and display the value on cell C6 to C8 skipping blank cells.
Thank you! Appreciate anyone's assistance on this.
I would like to get your expert advise on how to get around this issue I am encountering.
I am trying to populate a cells so that it will lookup the value from row while skipping blank cells within that row and displaying those values in a column.
So whenever a lookup value is populated on C3, it will lookup DataSheet sheet from Column B to O and display the value on cell C6 to C8 skipping blank cells.
Thank you! Appreciate anyone's assistance on this.