Question description:
This user has given permission to use the problem statement for this
blog.
I have a complex lookup formula but don't know why it isn't working now.
Solved by T. C. in 7 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
28/09/2017 - 07:12
Hello, welcome to excel chat.
Excelchat Expert
28/09/2017 - 07:12
How may I help you today?
User
28/09/2017 - 07:13
I want to know what is wrong with my lookup formula.
Excelchat Expert
28/09/2017 - 07:13
okay, let me see your formula and tell me what it do.
User
28/09/2017 - 07:15
Here, vlookup($A3,$B$3:$H30,2,0)
User
28/09/2017 - 07:15
I want to perform approxiamate match
Excelchat Expert
28/09/2017 - 07:16
the formula looks great.
Excelchat Expert
28/09/2017 - 07:16
just asking your data in column C are sorted right?
Excelchat Expert
28/09/2017 - 07:16
because approximate match requires data to be sorted.
User
28/09/2017 - 07:17
let me take a look.
User
28/09/2017 - 07:17
ah, man. thanks a lot.
User
28/09/2017 - 07:17
you are right. it isn't sorted.
Excelchat Expert
28/09/2017 - 07:17
my pleasure.
Excelchat Expert
28/09/2017 - 07:17
another tips.
Excelchat Expert
28/09/2017 - 07:18
since you are returning from col C, no need to expand your array towards col H.
Excelchat Expert
28/09/2017 - 07:18
I guessed you are returning data from col C since you have used col no 2.
User
28/09/2017 - 07:18
thanks, will do.
Excelchat Expert
28/09/2017 - 07:19
anyting else?
User
28/09/2017 - 07:19
nah, I'm fine.
Excelchat Expert
28/09/2017 - 07:19
okay, please end the session and rate my servie.
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
