Value match in a table plus formula?

[Chancy]

I'm pretty sure the terms I used are off, but I don't know what's right.
First, this formula works, but I want to use it PLUS A FORMULA (all in one formula):

IFERROR(VLOOKUP(VALUE(A1),Codes!$A$1:$B$30,2,0),VL OOKUP(TEXT(A1,0),Codes!$A$1:$B$30,2,0))

In the Codes tab, Col B data is text. In what I want to do but don't know how, Col B data can be either numeral or alpha (whatever makes this work).

So this part I have
[(Look up A1 in Table, when you find it, if resulting match is Y (yes) (or numeral, such as 2?),



and then part I do not have:

then [B2*2]]

Is this possible and what would the correct formula be? To try to be more clear, I don't want to just populate the cell with a value, I want to populate the cell with the result from a formula after the VLOOKUP part is completed.

Thanks