Lookup data in 2 worksheets

[hsandeep]

My Excel Workbook contains 2 worksheets…..tab named “M” & “MA”

In “MA”
Values are in B2:CA42

In “M”
In C500 (formula required for this cell)
I want to match A199 with B2:B42 (of “MA”) & get the corresponding value of BS column.

How to accomplish?

 

[DanteAmor]

In C500 (formula required for this cell)

=VLOOKUP(A199,MA!B2:BS42,70,0)

 

[hsandeep]

Thanks DanteAmor for your guidance.

It works…but I want to copy the formula across (on right side & below) also. How to deal with “70” in such cases?

 

[Fluff]

How about
=INDEX(MA!BS$2:BS$42,MATCH($A199,MA!$B$2:$B$42,0))