I have one spreadsheet in Google Sheets with data like: In sheet 1 in column pricelist
$100 in text 102 in Number $103 in text 104 in number 105 in number
When I do the
vlookup and try to multiply with 1 it is showing an error. Not able to understand how to make the change.
I have used this formula to convert text to number, but if the cell has number format then it is dropping an error.
The formula used to convert text to number: