Some function problems

  • Thread starter Thread starter timmyc
  • Start date Start date
T

timmyc

1) What function would i need to look down a list and bring back a nam
that corresponds to the highest number next to it. E.g. finding th
highest attendance and bringing back the name next to it? I have don
a max function then done a vlookup connected to that but this has no
worked correctly.

2) I have a combo box displaying the names of products in a shop and
scroll bar which displays numbers, both have been linked to cells and
have done the appropriate vlookup to bring back the name of the stock i
the cell below. What I would like to do is run a macro that will ad
the number of stock sold indicated by the scroll bar for the produc
selected by the combo box to the "No. of Stock Needed" on anothe
sheet. How would I do this? (I know how to record macros etc. its jus
the formula/functions/how to get the round the problem that I don
know.

Please help as this is coursework in for Friday!

Thanks, Ti
 
A1:A10 has names; b1:B10 has numbers
=INDEX(A1:A10,MATCH(MAX(B1:B10),B1:B10,0))
find the name associated with the max number
Max finds value of maximum;
MATCH find what row that value is in;
INDEX looks up a specific entry in an given array
best wishes
 
Back
Top