Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.
(so this just looks up the Letter part that is unique to the chosen date and then the number of the column the offset is for).
="'Stat Table'!" & SUBSTITUTE(TEXT(ADDRESS(1,MATCH($Q$1,$4:$4,0),4),""),"1","") & ROW(D6)
But I get an error message of #VALUE! , any ideas? The offset value works if I just point it directly at the cell like this: =OFFSET(H3,0,0,,'Stat Table'!$Q$2) for example
|VB loop to open the file from the network drive||30||67|
|In Excel 2007, how do I need to correct this ampersand formula so it works?||2||16|
|Excel split data and output all combinations.||2||24|
|Excel - clear contents when cell contents duplicated||4||19|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
13 Experts available now in Live!