A formula to vlookup with condition (b or s)

Hello,

thanks for checking.

i am looking for a formula that can vlooup according to the conditon,

in the sheet attached if col F =b then vlookup the table on the right

if col F=s then vlookup the same table but in negative sign


how can i put the check of b and s in a formula that can be applied to whole column.


thanks in advance

Gokz

just the opposite symbol for the values in the vlookup table.


for ex: if its "s" then formula =vlookup(....)

if its "b" then formula = -vlookup(....)

hope you got it.

thanks

gokz

hello sixth sense,

thanks fr the reply

but i am getting the same value (100) in the whole column with this formula.

any idea?

thanks

Gokz

that works awesome!!

thank you Sixthsense ...u rock as always

This one much shorter....

Make sure set your calcution to "Automatic" not "Manual"

In H2: =VLOOKUP(G2,M$5:N$7,2,0)*SIGN((F2="s")-0.1)

copy down

that tooo works well...

Thanks

You're Welcome!