Is it possible to do this in reverse? I want to return the minimum value of a table based on a vlookup. Look up name in a table and return the minimum date?
Can you help me? I want to vlookup value in column A and return smalles value from three same choices. Lets say i have Ann in A and her income in B 100 200 300 so i want to return Ann smallest income (usually I dont know how much it is)
Is it possible to do this in reverse? I want to return the minimum value of a table based on a vlookup. Look up name in a table and return the minimum date?
ok it's on the next one thanks
How do you look up the name to return the min or max value?
hi what if the names were in the first column and the number in second column. i tried a lot but it doesn't work for me
Can you help me? I want to vlookup value in column A and return smalles value from three same choices. Lets say i have Ann in A and her income in B 100 200 300 so i want to return Ann smallest income (usually I dont know how much it is)
It's work though thank you so much.
You're welcome!
what if there are more people than mike with 1000$??