I have a requirement to extract some data which under normal circumstances
would be easily accomplished as the formula =VLOOKUP(C2,$R$12:$T$1010,3,0) would return the correct result if R12 contained 301 and T12 contained XYZ i.e. XYZ would be returned. However, I want to return the contents of cell T13 which is always 1 rows below the match in column R.
Any help is always appreciated!
Bookmarks