Lookup Function - difficulties
Posted by Chase on September 06, 2001 3:31 PM
I by an earlier post - was recommended to try the lookup function. Basically we have one sheet ("figures" sheet) with nothing but model codes, model name and trim level.
When on sheet1, cell H9 equals a model code on "figures" sheet - let two additional cells on sheet1 pull cooresponding model name and trim level from that row that matches model code.
The lookup formula did indeed pull, but it pulled seemingly random. I couldnt determine any particular method to it's maddness. All column's & rows are same heigth.