First Post for the Excel Gurus - help needed

Hi , First post for me....

Can anyone help with what is possibly a simple problem.

I have a sheet which essentially has 3 columns
Part number , description and stock quantity

There are about 500 rows of parts with their description and quantity.
I need to be able to have a simple way for someone to enter a part number and excel will give them the description and quantity available without having to search through the list.

Is this easy?

Ray - UK

assuming all part numbers are different
use a v look up assuming your three colums are a b c
put this formula in e1

Please Login or Register  to view this content.

and in f1

Please Login or Register  to view this content.

then simply type part number in D1
if you don't want it to say #N/A when D1 is blank
use
something like in e1

Please Login or Register  to view this content.

and in f1

Please Login or Register  to view this content.

you can replace the text part with any text you like as long as its enclosed in ""
or just put 0 (zero ) without ""

Thanks Martin - this is spot on!

One last one if i may , how do i had a cell that if the quantity that is found is more than 0 , then it flags up "Use Stock"

I.e. if i put in a part number , and stock level found is more than "0" then a cell displays the wording "Use Stock"

Thanks

Ray

Thanks Martin - job done!

Regards

Ray

or a bit longer in g1 but it'll notify if part not not found

Please Login or Register  to view this content.