Offset a Named Range as the first cell in an Index | Match

[Shiseiji]

Hello all. As always, TIA!
I have a cell previously named so would like to use that rather than (MATCH(RC-9). My best isn't working:

.FormulaR1C1 = "=IF(ISERROR(MATCH(Range(ws_3Admin_UserLogOn).Offset(1,0),0)),""No Record"", INDEX(ws_2Users_RngEmpTyp, MATCH(Range(ws_3Admin_UserLogOn).Offset(1,0),ws_2Users_RngLogOn,0)))"

Appreciate the look.

Ron

 

[Legacy 143009]

You are missing your MATCH range in the first MATCH. Assuming ws_3Admin_UserLogOn is a single value and ws_2Users_RngLogOn is a range:

=IF(ISERROR(MATCH(Range(ws_3Admin_UserLogOn).Offset(1,0),ws_2Users_RngLogOn,0)),"No Record", INDEX(ws_2Users_RngEmpTyp, MATCH(Range(ws_3Admin_UserLogOn).Offset(1,0),ws_2Users_RngLogOn,0)))

By the way, this may work also:

=IFERROR(INDEX(ws_2Users_RngEmpTyp, MATCH(Range(ws_3Admin_UserLogOn).Offset(1,0),ws_2Users_RngLogOn,0)),"No Record")

 

[Shiseiji]

The things we can't see when we stare too long . . . much appreciated!

 

[Legacy 143009]

Glad it did help! Thanks for the feedback