# VLOOKUP MAX multiple value and write

#### ianski1143

##### New Member
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
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

#### mole999

##### Well-known Member
VLOOKUP deals with one value only, either exact or nearest, it won't return multiples

##### MrExcel MVP
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?

#### ianski1143

##### New Member

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.

#### ianski1143

##### New Member
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!!

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

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

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.

Does this mean yes?

#### ianski1143

##### New Member
Does this mean yes?

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

Sheet2
A B C
X Y Z
R G B

#### mole999

##### Well-known Member
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

Replies
0
Views
153
Replies
3
Views
382
Replies
6
Views
185
Replies
0
Views
286
Replies
3
Views
238

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

### 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.

### Which adblocker are you using?

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

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