Help with formula to find and return cell value Hello all, I have a spreadsheet

Question

Help with formula to find and return cell value

Hello all,

I have a spreadsheet as pictured below.

Would it be possible to have a formula on the same worksheet in say column Z that returns the value on row 1 that corresponds to the right-most column that has data in row 2?

For the table above, I would expect the returned value to be "Sep Wk3"

Any help would be greatly appreciated.

thanks all !

Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Sep Wk1 Sep Wk2 Sep Wk3 Sep Wk4 Sep Wk5 #N/A #N/A 98.8% 97.9% 97.4% 99.6% 100.0% 99.1% 100.0% 100.0% #N/A #N/A #N/A 100.0% 100.0% 98.6% #N/A #N/A 167 195 274 252 260 215 203 202 #N/A 46 78 71

Explanation / Answer

Hi,,,

try this in Col Z

=LOOKUP(2,1/(A3:Y3<>""),A1:Y1)

or if you want to drag it down

=LOOKUP((2,1/(A3:Y3<>""),$A$1:$Y$1))

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.