Mar 28 2021 10:45 PM
Hello Everyone,
I have done VLOOKUP function.
Like -
But i want solution in Code with Country.
Like - I should be come [100]India
So, what formula should i put?
Please Help?
Here is an attached file
Mar 29 2021 01:27 AM
Mar 29 2021 01:43 AM
Mar 29 2021 01:59 AM
Quotes " are used around fixed text values in a formula.
For example, ="Zan" returns the text Zan.
"" is an empty string (text value), and " " is a string consisting of a space.
& is the concatenation operator. For example, "Zan" & " " & "Hanifee" returns Zan Hanifee.
You wanted to concatenate the code enclosed in [ ] with the country.
To get the code enclosed in [ ] we use "[" & A2 & "]"
We concatenate this with the result of VLOOKUP:
="[" & A2 &"]" & VLOOKUP(...)
Mar 29 2021 02:14 AM
Apr 03 2021 04:30 AM
Hello Sir:smiling_face_with_smiling_eyes:
In my DATA sheet, there are 3 persons with one Emp ID,s
Like -
So, i want to match here. what formula should i write with the help of INDEX with MACTCH function in here -
And with the help of VLOOKUP function -
In simple way to say that - What formula should i write -
only VLOOKUP function(With VLOOKUP sheet)
AND
only INDEX WITH MATCH function(With Index with Match sheet)... Both..
Without creating a Helper Column.
Please Help.
Here is an attached file.
Apr 03 2021 07:24 AM
The attached version shows a way to do it using INDEX, SMALL and COUNTIF.
I don't know of a way to do it using VLOOKUP without a helper column.
Apr 03 2021 07:40 AM
Thank you so much sir:smiling_face_with_smiling_eyes:
1st question - Sir, please let me confirm that do you use Ctrl + Shift + Enter in the formula in this attached file?
2nd question - I have done VLOOKUP function with help of Helper column. So, please can you tell me that is this correct or not?
Here is a attached file
Apr 03 2021 08:05 AM
Thank you so much sir:smiling_face_with_smiling_eyes:
1st question - Sir, please let me confirm that do you use Ctrl + Shift + Enter in the formula in this attached file?
2nd question - I have done VLOOKUP function with help of Helper column. So, please can you tell me that is this correct or not?
Here is a attached file
Apr 03 2021 08:06 AM
1) Yes - if you look at the formula bar, you'll see { } around the formulas on the 'With INDEX and MATCH formula' sheet; this indicates that the formulas are array formulas confirmed with Ctrl+Shift+Enter.
2) Yes, that is the way to do it with a helper column.
Apr 03 2021 08:08 AM