Dynamic Vlookup

egeslani

New Member
Joined
Feb 15, 2002
Messages
27
I have numbers from A1 to A9 and have names from B1 to B9. On cell A10, I have formula =Max(A1:A9) and this is my lookup number.My lookup array is $A$1:$B$9. What I mean dynamic is if any value in cell A1 to A9 changes,the lookup value also change. I have tried several times but it works in few tries then it will stop.

Anyone could help me out?

Thanks,
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

DonkeyOte

MrExcel MVP
Joined
Sep 6, 2002
Messages
9,123
Should work so that sounds strange - have you checked that your calculation is set to automatic (in options).
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,209
On 2002-09-19 03:19, egeslani wrote:
I have numbers from A1 to A9 and have names from B1 to B9. On cell A10, I have formula =Max(A1:A9) and this is my lookup number.My lookup array is $A$1:$B$9. What I mean dynamic is if any value in cell A1 to A9 changes,the lookup value also change. I have tried several times but it works in few tries then it will stop.

Anyone could help me out?

Thanks,

Your formula should be something like

=VLOOKUP(MAX(A1:A9),A1:B9,2,0)

or

=INDEX(B1:B9,MATCH(MAX(A1:A9),A1:A9,0))
 

Forum statistics

Threads
1,144,436
Messages
5,724,343
Members
422,545
Latest member
zillafreak

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top