Return data from other sheet if data is in certain cells

[glomb175]

Hello, Excel noob here again.

In the attached, on 'End' sheet, in the highlighted cells, I'd like some formulas that say:

'If there is data in rows 11:12 or 17:18 on the Data sheet, then return the corresponding data from rows 1 and 2'.

There is an example of the desired outcome on the 'Example' sheet.

[José Augusto]

Try this formula

Please Login or Register  to view this content.

[Glenn Kennedy]

In A2:
=IFERROR(INDEX(Data!$1:$1,AGGREGATE(15,6,COLUMN(Data!$B$11:$E$18)/(ISNUMBER(Data!$B$11:$E$18)),ROWS($1:1))),"")

In B2:
=IFERROR(INDEX(Data!$2:$2,AGGREGATE(15,6,COLUMN(Data!$B$11:$E$18)/(ISNUMBER(Data!$B$11:$E$18)),ROWS($1:1))),"")

[José Augusto]

Or a more geral formula

Please Login or Register  to view this content.

and copy down and forward

[AliGW]

This is a duplicate thread, and as such is closed.

You may have one thread only per issue - please continue in your other thread, which has more responses.