**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.*