=VLOOKUP(cat_num,B:D,2,False)

=VLOOKUP(cat_num,B:D,3,False)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"george24" wrote in message
...
I would like to find the correct formulas for the next example:
at the column "A" i have all the items numbers, at the column "b" all the
catalog numbers, at the colum "c" i have the cost of their respective
item,
and at the colum "d" i have all the descriptions of each items.

-I would like a formula that after I wrote the Item number or catalog
number
at the column "E" row 3 can display his respective cost.
-I would like a formula that after I wrote the Item number or catalog
number
at the column "E" row 3 can display his respective description.
--
Thanks for you support and sorry for my english