Driving me mad. I had this working perfectly. Now for some reason, it's not
It either comes up with a spill error, or doesn't work at all. Not sure if I can share the workbook?
Honestly, I had this code sorted weeks ago, and it's been running fine.
I've checked previous versions and it's not working on there either... no idea what I have done...
=IF(ISNA(VLOOKUP(B10:B28,'Master Price List'!$B$7:$F$5000,5,FALSE)),"",VLOOKUP(B10:B28,'Master Price List'!$B$7:$F$5000,5,FALSE))
And then it worked again, and then stopped.... arrghhh...
It either comes up with a spill error, or doesn't work at all. Not sure if I can share the workbook?
Honestly, I had this code sorted weeks ago, and it's been running fine.
I've checked previous versions and it's not working on there either... no idea what I have done...
=IF(ISNA(VLOOKUP(B10:B28,'Master Price List'!$B$7:$F$5000,5,FALSE)),"",VLOOKUP(B10:B28,'Master Price List'!$B$7:$F$5000,5,FALSE))
And then it worked again, and then stopped.... arrghhh...