returning more than one result...

[Mel]

I need help with a function.

Example of table:

B6:6688
B7:6681
B8:6685
B9:6681

F6:A
F7:A+
F8:A
F9:C

P5:1491
P6:6681
P7:6682

What I need to do: I need a formula to search the B6:B9
for in the # in cell P6 and if it matches, to return the
letter grade in Column F. The problem I am having is
Column B has repeated #s (which are not and can not be in
ascending order). I need the formula to return ALL the
Column F results that match P6.

I figured out to return the first match, but I need ALL
the matches. This is the formula I have right now for
the first match.

=VLOOKUP($P6,$B$6:$F$9,{5,1},FALSE)

Thanks for any help.

 

[Guest]

-----Original Message-----
I need help with a function.

Example of table:

B6:6688
B7:6681
B8:6685
B9:6681

F6:A
F7:A+
F8:A
F9:C

P5:1491
P6:6681
P7:6682

What I need to do: I need a formula to search the B6:B9
for in the # in cell P6 and if it matches, to return the
letter grade in Column F. The problem I am having is
Column B has repeated #s (which are not and can not be in
ascending order). I need the formula to return ALL the
Column F results that match P6.

I figured out to return the first match, but I need ALL
the matches. This is the formula I have right now for
the first match.

=VLOOKUP($P6,$B$6:$F$9,{5,1},FALSE)

Thanks for any help.

Your VLOOKUP will not work.

It is difficult to understand the logic behind your
spreadsheet. 6681 = A+ and 6681 also = c???

Perhaps you can give some detail as to what you are trying
to do and what the columns stand for.>

 

[Guest]

The #s in Column B are codes for classes offered. The
letters in Column F are the letter grades the student
received. A student can take more than one course with
the same code, hence receiving two letter grades.

Does this help?

 

[Dave Peterson]

Maybe a user defined function:

http://groups.google.com/[email protected]