Find match column of data within CSE formula

[jeffreybrown]

Currently have this formula working to return the name in column A on the PWLFs tab when the range B3:B28 on the PWLFs tab in not equal to nothing.

CSE

Please Login or Register  to view this content.

In reality, I need this part >> PWLFs!$B$3:$B$28<>"" >> to span B3:D28.

I thought I could change the formula too (using named ranges)

Please Login or Register  to view this content.

but I get a #REF! error.

Any thoughts?

[DonkeyOte]

Jeff, could you outline the Name definitions.

[jeffreybrown]

Hi Luke,

Sorry for the delay but many things going on yesterday.

Anyway, talking this through and looking at the named ranges, it dawned on me I had the Index/Match referencing the row_num as if it was the column_num since that is what the match was based on.

Ended up with...

Please Login or Register  to view this content.

...and it seems to do the job.