Making a letter point to a specific cell or equation?

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,339
Office Version
2019, 2016, 2013
Platform
Windows
The ZERO in MATCH should set for exact only

a little concerned about B$3:B$6 as that indicates to me only three rows are referenced

you might wrap with IFERROR(... formula ... ,"")
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Watch MrExcel Video

Forum statistics

Threads
1,099,580
Messages
5,469,507
Members
406,656
Latest member
Kriscrawford76

This Week's Hot Topics

Top