Help Required Please...

[ExcelRoy]

Hi,

I am having some trouble with excel, and wonder if you could help me please

i have 2 columns A and B

Column A has part numbers and Column B has description

I would like to create a "booking out tab" of selected parts

when i type say "1" in cell A1 then i would like it to show the descriptions in cell B1, but if i type "2" the i would like it to show cell "B2", etc

to save me typing the descriptions out all the time

not sure if this can be done

i have the basic formula for this but need it for every part in my inventory (say 100 lines)

=IF(A1=G1,Supplier!B1) G1 is just a copied cell of A1
=IF(A2=G2,Supplier!B1) G2 is just a copied cell of A2
etc

i would be gratefull if you could help me out

kind regards

 

[acw]

Hi

Have a look at the VLOOKUP function. The way I read your description this should give you what you are chasing.


Tony