Hello All
please could you help me change this formula
A67 = £0.00
how do i change it to look for a blank cell as well
ho do i replace the &A67 with {"£0.00",0,""}
Thank you Jason
please could you help me change this formula
VBA Code:
=IFNA(INDEX(Download!$J$2:$J$9999,MATCH(B67&"|"&A67,INDEX(Download!$F$2:$F$9999&"|"&Download!$Q$2:$Q$9999,0),0)),"")
A67 = £0.00
how do i change it to look for a blank cell as well
ho do i replace the &A67 with {"£0.00",0,""}
Thank you Jason