I want to use "Indirect" in my VLookup to give the starting range to search.
I want to substitute, Indirect(E16) for $B$1 in the following formula.
Any help would be greatly appreciated.
Thank you.
=IF(ISERROR(VLOOKUP($C$8,'Relativity Summary'!$B$1:$J$65536,9,FALSE)),"No More",VLOOKUP($C$8,'Relativity Summary'!$B$1:$J$65536,9,FALSE))
Justine
Bookmarks