I have a spreadsheet in Google Sheets with data like this:
In sheet 2, in column pricelist, the below data is there. I want the summary in sheet 1 to have the same. I have used
match but it is not working.
$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. I don't understand how to make the change.
I have used this formula to convert text to numbers, but if the cell has a number format then it is showing an error.
The formula used to convert text to numbers: