Thread: 43 Columns
View Single Post
  #1   Report Post  
Gee...
 
Posts: n/a
Default 43 Columns

Why won't this work:

VLOOKUP($A$4,INDIRECT(CONCATENATE("'",C$2,"'!$A:$A Q"),1),44,FALSE)

When I use ",43,FALSE) and any other column before that it works fine...but
it returns a #REF past 43...another Excel quirk?

Thank you in advance for your help.