LOOKUP a matching value

Hi. Forum Rule 1 is very short. It states: "Title must briefly summarize your request."

A GOOD thread title is the sort of thing you would use as a search term on Google*. Your chosen title would produce a squillion useless hits. In future, please take a bit more time to think of a descriptive title that would be "Google-friendly". Many people search the forum answers looking for help and your very general title wouldn't help them at all.

Since you are a new user of this site, on this occasion, I have changed it for you.

However, if you continue to use weak titles, you can expect to have your thread BLOCKED until you change it yourself. If that happens, to edit the thread title, open the original post, click "Edit Post" (bottom right) to access the area where you can edit your title.

*Other search engines are available!!!

Regards,

Glenn.

Your values in column C are formatted as Text, those in column B as numbers. That's your problem. EXACTLY which values are you wanting to return???

Select the data in column C.

Data/Text to columns/Finish.
Reformat columns C & D as numbers.

And next time... [lease read the yellow banner at the top of the screen. A sample should be 10-20 rows.... not 9000.

Pl see file working.

Originally Posted by imranhabib01

i changed the format general to numbers of that coloumn but it does not work

Formatting doesn't alter the underlying value.
In your case the column C 'numbers' are text. To correct put a zero in a cell and copy it. Then select the column C range and use Paste Special Add to convert them all to numbers.

You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

I don't understand what you want!

Please post a SMALL sample sheet showing some expected answers (manually calculated)!!