google sheets – Convert number and text to number

I have a spreadsheet in Google Sheets with data such as:
In sheet 1 in column price list

$ 100 in text
102 in number
$ 103 in text
104 in number
105 in number

When I make the vlookup and try to multiply it by 1, it indicates an error. Unable to understand how to make the change

I used this formula to convert text to number, but if the cell has a numeric format, it removes an error.

Formula used to convert text to number.
roundup (REGEXREPLACE (index (Sheet1! A: A, match (E3, Sheet1! A: A, 0), "),", "[$,*]"))