Lookup & Match?

[jimboy]

Hi - I need a formula to look up a name and then find the nearest figure under the sales figure in the table - and bring back the data in the third column of the table.

i.e. in A1:C7 is the table, in A11 & B11 is the values to look up and C11 is the were I want the formula.

Thanks.
PS I know I'm crap at explaining this!

******** ******************** ************************************************************************>

Microsoft Excel - Book8 ___Running: xl2000 : OS = Windows Windows 2000
(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
A1 =
	A	B	C	D
1	Name	Sales	Comm
2	Steve S	0	1%
3	Steve S	150	2%
4	Steve S	350	3%
5	John T	0	1%
6	John T	250	2%
7	John T	500	3%
8
9
10	Name	Sales	Formula need here to bring back these results
11	Steve S	75	1%
12	John T	350	2%
13
14	Steve S	450	3%
15	John T	150	2%
Sheet1

[HtmlMaker 2.32] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.


PPS. Have done it naming ranges and using vlookup & indirect - but it takes ages to name all the ranges!