Hello.
Am new to excel and i need some help for an excel formula. Below is the scenario:
Got the following data in different cells:
And on a different sheet in the same workbook, have 45 different values to be converted:
What is required?
Knowing that using a VLOOKUP function, i can compare a value in the first cell to the list and return the desired value, i need to substitute the strings of characters with those the the list of 45 values so that i can proceed with my work.
Basically, for the 1st Cell for eg..
2232-2232-
I will need a formula to replace "2232-" by the value which a VLOOKUP function will give when comparing to the list of 45.
Result shall look like below:
20-20-
Looks simple when have the same set of characters in the cell, but for a cell which has multiple sets:
It becomes difficult for me. What i need exactly is:
Formula to substitute using the vlookup function so that it performs a lookup of the value in the specified cell with the list of 45 values and returns the value (20- or 40-) to be substituted in the cell. What i need finally is a set of 20- & 40- replacing the sets of present data.
Your help will be much appreciated.
Am new to excel and i need some help for an excel formula. Below is the scenario:
Got the following data in different cells:
And on a different sheet in the same workbook, have 45 different values to be converted:
What is required?
Knowing that using a VLOOKUP function, i can compare a value in the first cell to the list and return the desired value, i need to substitute the strings of characters with those the the list of 45 values so that i can proceed with my work.
Basically, for the 1st Cell for eg..
2232-2232-
I will need a formula to replace "2232-" by the value which a VLOOKUP function will give when comparing to the list of 45.
Result shall look like below:
20-20-
Looks simple when have the same set of characters in the cell, but for a cell which has multiple sets:
Code:
2210-22G1-45R1-45G1-20R1-20GP-
It becomes difficult for me. What i need exactly is:
Formula to substitute using the vlookup function so that it performs a lookup of the value in the specified cell with the list of 45 values and returns the value (20- or 40-) to be substituted in the cell. What i need finally is a set of 20- & 40- replacing the sets of present data.
Your help will be much appreciated.