VBA Absolute reference not working...

[leatherhen99]

Today has been one of those days! Can someone help?!?

I am referencing a pivottable on another sheet...

This formula:

ActiveCell.FormulaR1C1 = "=iferror(index('" & PSheet.Name & "'!r4c3:r" & LastRow & "c" & LastCol & ",match(rc[-1],'" & PSheet.Name & "'!r4c2:r" & LastRow & "c2,0)" & ",match(r2c[0],'" & PSheet.Name & "'!r3c3:r3c" & LastCol & ",0)),"""")"

=IFERROR(INDEX(PivotTable!$C$4:$CB$179,MATCH(A3,PivotTable!$B$4:$B$179,0),MATCH(B$2,PivotTable!$C$3:$CB$3,0)),"")

match(rc[-1] is giving me MATCH(A3

My problem is the A3 highlighted in the match... it's giving the correct cell reference; however, I need it to be $A3 so that it remains in column A... When I add R0c[-1], I end up either getting nothing...or a @ symbol in my formula which is canceled by the iferror statement with nothing.

I've scoured these message boards, and apparently, this hasn't come up for anyone else...

Any help would be greatly appreciated!!!
Heather

 

[DanteAmor]

Try this

match(rc1

 

[leatherhen99]

Try this

match(rc1

Thank you so much! I guess I couldn't see the forest for the trees! That worked perfectly! Thank you soooooo much!

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.