Hi Team,
Need support.
I have 2 sets of Data
One set of Data is as below
In another excel sheet i have a value ZS-DR. for this code i need excel to pick the value 50% from the above table.
How can this be possible using vookup.
Appreciate your support
Need support.
I have 2 sets of Data
One set of Data is as below
Code | Value |
ZS-D* | 50% |
FL-** | 25% |
ZV-* | 30% |
ZV-K* | 25% |
FL | 40% |
In another excel sheet i have a value ZS-DR. for this code i need excel to pick the value 50% from the above table.
How can this be possible using vookup.
Appreciate your support