I am trying to nest an address in vlookup() for the table array without luck. Is this not allowed?
IE: the table array is located at L:M
VLOOKUP(I6,N1:M,2) where N1=L
I get the #NAME error
I am trying to nest an address in vlookup() for the table array without luck. Is this not allowed?
IE: the table array is located at L:M
VLOOKUP(I6,N1:M,2) where N1=L
I get the #NAME error
You could use INDIRECT
=VLOOKUP(I6,INDIRECT(N1&":M"),2)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks