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), "),", "[$,*]"))