Excel 2007 : VLookup Help

[StevenP138]

Is there a way to get the vlookup to give the second (or thrird, forth, etc.) item it finds?
Example:
I have a sheet with the following part numbers in it:
36-244
36-244-3DB
36-244-KP
36-244SS

When I type 36-244* into cell A1 it always grabs the first on it finds. Is there a way to tell it to grab the second or third one it finds?

Is VLookup the wrong function to use? Is there someting else I should be using?

Thank You
Steven

[jeffreybrown]

Hi Steven,

I would look into something like Advanced Filter