Good morning,
I was wondering if someone can help me out with the syntax for the following:
=IFERROR(OFFSET(INDIRECT(SUBSTITUTE($K8," ","")&"Code"),0,0,1),"")
---> right now, it returns with the value "$K8Code"
what should be the syntax so that it will return with "CODE$K8" ?
Thanks.
Last edited by jfrago; 02-17-2010 at 10:11 PM.
Got it!
=IFERROR(OFFSET(INDIRECT("CODE"&SUBSTITUTE($K8," ","")),0,0,1),"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks