While using a macro, I am trying to paste the following formula into cell J2:
=IF(B2="258801",VLOOKUP(G2,Matrix!A:L,4,FALSE),IF(B2="258701",VLOOKUP(G2,Matrix!A:L,5,FALSE),IF(B2="258601",VLOOKUP(G2,Matrix!A:L,5,FALSE),IF(B2="258501",VLOOKUP(G2,Matrix!A:L,6,FALSE),IF(B2="258101",VLOOKUP(G2,Matrix!A:L,7,FALSE),IF(B2="252201",VLOOKUP(G2,Matrix!A:L,8,FALSE),IF(B2="258301",VLOOKUP(G2,Matrix!A:L,9,FALSE),"")))))))&IF(B2="258401",VLOOKUP(G2,Matrix!A:L,10,FALSE),IF(B2="258401",VLOOKUP(G2,Matrix!A:L,10,FALSE),""))
When I begin recording my macro, even if that is the only thing I do, I still get an error when I try to begin recording, select the cell, click in to edit it, paste my fomula, and then stop recording.
The error is as follows:
Can anyone help? Thank yoU!
Bookmarks