"Whayne" wrote:

I want users to type in a part number in one cell "A1" then in cell "A2" I
would like the description of the part to appear. In cell A3 the price of
part should show up, etc
I have set so part numbers are on a master sheet (column A) with description
(column B) and Price (column C), etc beside. Each seperate sheet in file
uses different part combinations. I need the formula to "hunt" for the part
number in a range and return the corresponding values in the adjacent cells.
Example typing number PT1(part 1) in cell A1 returns corresponding part 1
description in cell B1 and part price in Cell C1. The tricky part is that if
in cell A2 I type a part number that isnt the second part in the parts master
list then the statements does not work. I realize that I will have to have
separate statements for columns b & C. Please help


I'm not 100% clear with what you want to do but if I'm right, and you want
to lookup the value next to your part number then HLookup sounds like a
better function than an IF Statement.

Hlookup is as follows:
=Hlookup(LookupVal,TableArray,Index,Lookup)

So assuming your lookup value is in Column A, =Hlookup("Part1",A1:C3,1)
'Would return the value in column B that is next to your lookup item. to
lookup the value is column C, increment the index (i.e.
=Hlookup("Part1",A1:C3,2) Hope this makes sense.

If I've missed your objective, let me know and I'll have another try!

James Nicholls