Vlookup and Multiple

[SoFlo24]

Hello all,

I'm afraid I am a bit over my head. I'm trying to create a formula where after I do a Vlookup for column A if it has a certain text it multiples what is in column B and puts it in column C. On my second sheet I have the following, see below, which is where it will draw the info from.

So on my first sheet if A has K001 it takes what's in B multiples .01 which is on my second sheet and displays it in column C on my first sheet and if it has K002 it will multiple it by .02 and display it in C

Code	D1
K001	0.01​
K002	0.02​
K003	0.03​

 

[Fluff]

Hi & welcome to MrExcel.
How about
=B2*Iferror(vlookup(A2,Sheet2!A2:B100,2,0),1)

 

[SoFlo24]

Hi & welcome to MrExcel.
How about
=B2*Iferror(vlookup(A2,Sheet2!A2:B100,2,0),1)

This worked, Thank you so much

 

[Fluff]

You're welcome & thanks for the feedback.