Hi i am using this below but i need to return Column C on Detailed_view. You can see ,1 this returns D, but i need to return C before D. I tried -1 but that doesn't work.
=IFERROR(VLOOKUP(@$D$8:$D$694, Detailed_View!$D$2:$P$395,1,0),"")
=IFERROR(VLOOKUP(@$D$8:$D$694, Detailed_View!$D$2:$P$395,1,0),"")