Help with Pulling Data from Multiple sheets using Indirect Formual.

Afternoon all,

Im trying to use Indirect to pull data from multiple sheets into one, however i need it to skip the data if there is in the other column.

So for example if Column B is the data to pull, if A4 has a value then it wont pull the data from there and will skip to A5 that has no value and pull the data from B5.

This needs to be continue as the sheets have data from Row 4 to Row 300/350. but only up to 10 data values needing to be pulled.

Not saying I'll solve this but

Sounds fiddly, so...

Post a sample spreadsheet with expected results, remove any sensitive data, create a mockup example if necessary.
Use the Go Advanced option at the bottom of the page then scroll down to Manage Attachments as the "paperclip" method does not work on this forum.

Not sure about this.

Please try at A2 drag across and down

=INDEX(INDIRECT($C$1&"!D:G"),AGGREGATE(15,6,ROW(A$4:A$350)/(INDIRECT($C$1&"!b4:B350")=""),ROWS(A$2:A2)),4-MOD(COLUMN(),3)-(COLUMN()=2))&""

Please provide more sample

Administrative Note:

We would very much like to help you with your query, however the thread title does not really convey what your request is about.
Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

Please try at A2:C2

Formula:

Please Login or Register  to view this content.

D2
=TRIM(RIGHT(SUBSTITUTE(LOOKUP(2,1/(LEFT($C$1:$C1)="s"),$C$1:$C1),"_",REPT(" ",9)),9))


copy A2:D16 to A18, A34, …