INDEX/MATCH


Posted by Mike on November 09, 2001 1:25 PM

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



Posted by Aladin Akyurek on November 09, 2001 1:30 PM


=INDEX(Hardware!$B$3:$B$180,MATCH(K366,Hardware!A3:A180,0))

shouls also work, where A3:A180 houses the P/N's and B3:B180 the desc's.

Aladin

========