Posted by Mike on November 09, 2001 12:40 PM
I have a simple on ehere which is driving me nuts.
Just trying out the Index/Match function and I keep getting a #N/A.
All I want to do is enter the P/N in a cell on
worksheet B, have the formula go to go to
worksheet A (Sheet Labeled "Hardware" , find the P/N and pull the desc.
Works fine with the VLOOKUP.
Sheet A lists all the Hardware I will need. (P/N in Col A, and Desc in Col B).
I write my formula on worksheet B as follows:
I figure it reads; GOTO "Hareware" Sheet and look in Range A3-A180 for a Match on sheet B at K336 (which is the P/N). Locate the P/N on the Sheet A, in Col B and Pull the Desc.
Does anyone see my error?