Help with function

[Kathleen_0422]

Hello Excel Gurus

I have never used the INDEX function but I believe I have seen where it has been used to replacing a VLOOKUP

Here is my problem

I have two sheets: Retired and Prior NBV

On the Retired Sheet Asset IDs are listed in column A

On the Prior NBV Sheet The Asset ID is located in Column H but I need to pull the Ledger Account from Column C on this sheet and place it along side the Asset ID in Column B on the Retired Sheet

How would I go about doing this via a formula?

Thank you in advance for your advice

 

[MrKowz]

Try:

=INDEX('Prior NBV'!C:C,MATCH(A1,'Prior NBV'H:H,0))

 

[T. Valko]

Hello Excel Gurus

I have never used the INDEX function but I believe I have seen where it has been used to replacing a VLOOKUP

Here is my problem

I have two sheets: Retired and Prior NBV

On the Retired Sheet Asset IDs are listed in column A

On the Prior NBV Sheet The Asset ID is located in Column H but I need to pull the Ledger Account from Column C on this sheet and place it along side the Asset ID in Column B on the Retired Sheet

How would I go about doing this via a formula?

Thank you in advance for your advice

Try it like this...

=INDEX('Prior NBV'!C$2:C$100,MATCH(A2,'Prior NBV'!H$2:H$100,0))

 

[Andrew Poulsom]

Try:

=INDEX('Prior NBV'!C:C,MATCH(A2,'Prior NBV'!H:H,FALSE))

For a tutorial see:

http://www.contextures.com/xlFunctions03.html

 

[Kathleen_0422]

Thank you all for such a quick response. I appreciate your help.

 

[T. Valko]

Thank you all for such a quick response. I appreciate your help.

You're welcome. Thanks for the feedback!