Can you please hel me to find the correct formulas

[george24]

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.

 

[Bob Phillips]

=VLOOKUP(cat_num,B,2,False)

=VLOOKUP(cat_num,B,3,False)

--
HTH

Bob Phillips

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