help with an index/match formula

[lizsunnysideup]

Hello,

I was wondering if someone could please help me with this formula:

=INDEX('[Commercial FRM for Claims Review.xlsx]Medications'!$E$2:$E$28460,MATCH(P7,'[Commercial FRM for Claims Review.xlsx]Medications'!$C$2:$C$28460,0))

What I'm hoping to do is transfer the data for columns E-G from one workbook to columns B-D in another workbook. Right now I am only able to repeat this formula separately 3 times for each column.

Thanks for looking at this.

 

[Fluff]

If you use
=INDEX('[Commercial FRM for Claims Review.xlsx]Medications'!E$2:E$28460,MATCH($P7,'[Commercial FRM for Claims Review.xlsx]Medications'!$C$2:$C$28460,0))
Then you can drag it down & across

 

[lizsunnysideup]

OMG! Thank you soooo much, it worked!! Have an awesome day, and thanks again for the help.

 

[Fluff]

You're welcome & thanks for the feedback