Lock the index/match going across the whole row in one shot

[sblue827]

I want to be able to lock the formula across the row without doing it one cell at a time. I'll use examples down below to try to explain what I'm looking to accomplish.

What I used to slide all the way across the row so I could keep the constant formula for one person in column A: =IFNA(INDEX('Items'!B:B,MATCH($A:$A,'Items'!$A:$A,0)),"") =IFNA(INDEX('Items'!C:C,MATCH($A:$A,'Items'!$A:$A,0)),"") =IFNA(INDEX('Items'!D:D,MATCH($A:$A,'Items'!$A:$A,0)),""), etc....

Example of what I then have to do from the beginning of the row after the previous step: =IFNA(INDEX('Items'!B:B,MATCH($A:$A,'Items'!$A:$A,0)),"") Click B:B with the mouse then hitting F4 and tab to next cell. I keep having to do this over and over again going down the row.

What I'm looking to accomplish with shortcut or however you do it all in one shot: =IFNA(INDEX('Items'!$B:$B,MATCH($A:$A,'Items'!$A:$A,0)),"") =IFNA(INDEX('Items'!$C:$C,MATCH($A:$A,'Items'!$A:$A,0)),"") =IFNA(INDEX('Items'!$D:$D,MATCH($A:$A,'Items'!$A:$A,0)),""), ETC...

 

[Fluff]

Hi & welcome to MrExcel.
Why do you need to lock the column your indexing?

 

[sblue827]

Hi & welcome to MrExcel.
Why do you need to lock the column your indexing?

Thanks for the welcome and I already love this site and wish I found it a while ago. I can see it will be bringing plenty of help and creative ideas to my models and data. After further research I realized my thinking and logic was wrong on this one. Looks like I was making a rookie mistake with the absolute reference key. ?‍

 

[Fluff]

Glad to help & thanks for the feedback.