Forum Discussion
Question related to vlookup multiple criteria
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
10 Replies
Thank you so much sir😊
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
- it worked! Thank you so much sir😊😊
1st question --- I do not understand that why we put "["&$A2&"]"& .Please explain?
2nd question --- Sir, i want to understand full details of wildcards like -
" "
--
?
&
And so on.
Can you please share a details or Link of wildcards that i will learn ? PleaseQuotes " 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(...)
