INDEX/MATCH

Well I figured out the MATCH function and it worked fine. I was selecting the wrong Array. It appeared that I was looking in the Desc column for the P/N, instead of the P/N Column. The 2 at the end pulls the adjacent inforamtion (in this case the Desc) from column 2.

Formula lookes like this:
=INDEX(Hardware!$A$3:$B$180,MATCH(K366,Hardware!A3:A180,0),2)

Thanks for your help.

I will be Back at some point in time.
I've been learning how to work with Macros.

Mike