VLOOKUP MAX multiple value and write

ianski1143

New Member
Joined
Nov 27, 2016
Messages
5
Hi All,

help me below condition pleassssse..
lookup column A and find the max value C and write the answer B

Sheet1
A B C

X P
Y F

Sheet2
A B C

X F 1
Y P 1
X F 2
X P 3
Y F 2
 

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

ianski1143

New Member
Joined
Nov 27, 2016
Messages
5
RESEND

help me below condition pleassssse..
lookup column A and find the max value C and write the answer B

Sheet1
A B C

X Pass <--lookup X
Y Fail <--lookup Y

Sheet2
A B C

X Fail 1
Y Pass 1
X Pass 3
X Fail 2
Y Fail 2
 
Upvote 0

mole999

Well-known Member
Joined
Oct 23, 2004
Messages
10,524
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
VLOOKUP deals with one value only, either exact or nearest, it won't return multiples
 
Upvote 0

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,210
RESEND

help me below condition pleassssse..
lookup column A and find the max value C and write the answer B

Sheet1
A B C

X Pass <--lookup X
Y Fail <--lookup Y

Sheet2
A B C

X Fail 1
Y Pass 1
X Pass 3
X Fail 2
Y Fail 2

Are you looking for the max value X and Y in C1 and C2 of Sheet1, i.e. 2 and 3?
 
Upvote 0

ianski1143

New Member
Joined
Nov 27, 2016
Messages
5
Hi Aladin,

I'm looking for max value of X and Y to printout the result of column B of sheet2 to X and Y of sheet1.
 
Upvote 0

ianski1143

New Member
Joined
Nov 27, 2016
Messages
5
VLOOKUP deals with one value only, either exact or nearest, it won't return multiples

@Mole now I did sort my sheet2 from highest to lowest to lookup the MAX value of X and Y and write the value of column C and its work! thanks!!

now i have new problem.please help??

A B C
X Z <-- if X = Y then write Z
R B <-- if R = G then write B

A B C
X Y Z
R G B
 
Upvote 0

mole999

Well-known Member
Joined
Oct 23, 2004
Messages
10,524
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
can you use one of the html makers to make a bigger table that shows a number of results, from the few you have, i'm not sure what more would look like
 
Upvote 0

Forum statistics

Threads
1,191,173
Messages
5,985,095
Members
439,940
Latest member
Kyrad42

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