LinkBack URL
About LinkBacks
Is it possible to use index match with named ranges? I keep getting #value! or #N/A.
My named ranges are: Data_Table, Year_Range, Column_Range.
=INDEX(Data_Table,MATCH(H5,Year_Range,0),MATCH(H4,Column_Range,0))
Is it possible to use index match with named ranges? I keep getting #value! or #N/A.
My named ranges are: Data_Table, Year_Range, Column_Range.=INDEX(Data_Table,MATCH(H5,Year_Range,0),MATCH(H4,Column_Range,0))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks