VLOOKUP MAX multiple value and write

[ianski1143]

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

 

[ianski1143]

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]

VLOOKUP deals with one value only, either exact or nearest, it won't return multiples

 

[Aladin Akyurek]

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]

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.

 

[ianski1143]

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

 

[Aladin Akyurek]

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

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.

Does this mean yes?

 

[ianski1143]

Does this mean yes?

Yes aladin. this one done already. please help me on the situation below. Thanks

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]

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