Can you please hel me to find the correct formulas

G

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.
 
B

Bob Phillips

=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)
 
Top