I've been using a nested Vlookup Index formula that has worked perfectly, however now I have adapted it in another worksheet to similar data (merely a different time frame) and I am getting intermittant #N/A errors, while most of the results are coming out fine. The columns are NOT formatted as text; one is formatted as general, the other is formatted as number. There doesn't seem to be a pattern as to the errors; they are occuring no more than once per row and nearly but not all rows, and in different columns. The data is available (not blank) in the cells being referred to.
Here is the first row and column of the formula: =VLOOKUP(B$1,INDEX(TransferPIWeekly!$A:$A,(ROWS(B$2:B2)-1)*8+2):INDEX(TransferPIWeekly!$B:$B,ROWS(B$2:B2)*8+1),2,0)
Any help would be most welcome! This has me totally perplexed.
Stevie the Kid
Bookmarks