Substitute function within an if statement?

[shanaDC]

Hi,

I'm trying to write an easy formula that I can imbed within a formula that returns a value from another sheet:

=IF(ISBLANK('Raw Data'!H36),"",'Raw Data'!H36)

That formula will return the revenues of companies (stored on another sheet), but some of these pulled values are written incorrectly, ie as "5k" or "5bil" instead of 5000 or 5000000000. Is there a way to imbed a substitute/replace function within my original "if" statement? I don't want to just manually do find and replace, since this is a large and rather complicated data set. Thanks!!

[AlKey]

Maybe like this

=LOOKUP(1E+307,0+LEFT(A1,ROW(A$1:A$10000)))*LOOKUP(2^15,SEARCH({"K","Mil","Bil"},A1),{1000,1000000,1000000000})

	A	B
1	105K	105,000
2	120Mil	120,000,000
3	25Bil	25,000,000,000
4	135K	135,000
5	173K	173,000
6	2300Mil	230,000,000