Question about Vlookup approximate Match

[Scott M]

Does any one know of a way to use Vlookup approximate match to return the value of a cell that is the next highest. For example I have a value in sheet1 A2 of 34 1/2.The Vlookup is looking at the following values in sheet2 A2 (20) A3 (23) A4 (27) A5 (33) A6 (38) .It returns The value of A5 (33).I know that this is what is suppose to happen but I would like it to return the value in A6 (38). Is this possable?

 

[Jonmo1]

Sort the data DEscending, and use

=INDEX(Sheet2!A2:A6,MATCH(A2,Sheet2!A2:A6,-1))