Hi,
My name is Dan, and I have a concatenate problem.
My formula currently reads as follows:
=VLOOKUP($A2,Year1!$C:$U,COLUMN(Year1!$U:$U)-COLUMN(Year1!$C:$C)+1,FALSE)
If it's possible, I would like to replace the Year1 reference components, which are referencing another sheet in the workbook, to a cell reference in the same sheet. I came up with the following:
=VLOOKUP($A2,CONCATENATE(B1,"!$C:$U"),COLUMN(Year1!$U:$U)-COLUMN(Year1!$C:$C)+1,FALSE)
where B1 is a reference that contains the text "Year1". I am receiving a #Value error. Is the problem that Vlookup does not like to have a concatenate embedded in it?
Thanks
-Dan
Bookmarks