VLOOKUP issue

[abanerji]

I have a problem in getting VLOOKUP to evaluate consistently. It is best understood from the screenshot linked (Office 2010), where cells B3 and B4 are not showing the expected values. I wanted to upload the excel file, but cannot see the option to do it.

The screenshot is at Book2 | Flickr - Photo Sharing!

This is just a small segment of the big excel sheet, and so a global solution is required.

How to get it right please?

{mod removed bad img tag}

 

[cml19722000]

Try to add Value() into your Vlookup equation.

=VLOOKUP(Value(A10),F2:G5,2,FALSE)

if this not able to solve your problem~ then try to convert your text into value before Vlookup().

 

[Aladin Akyurek]

Care to post the formula you have?

 

[abanerji]

Thanks a lot. Your formula is brilliant. It worked!

Try to add Value() into your Vlookup equation.

=VLOOKUP(Value(A10),F2:G5,2,FALSE)

if this not able to solve your problem~ then try to convert your text into value before Vlookup().

 

[abanerji]

My formula is clearly visible in the linked screenshot (already in OP) Book2 | Flickr - Photo Sharing!

Care to post the formula you have?

 

[Fotis1991]

Very nice....... So many people in 3(only???) forums work for you....

VLOOKUP issue

VLOOKUP issue

And a message for you.

Excelguru Help Site - A message to forum cross posters

 

[abanerji]

Just to clarify on Fotis' post.

When my company wants a quick answer (like yesterday), I am forced to seek the most suitable answer. More so, when in-house resource could not help.

In my internet search for a ready answer, I did not come across one, and so posted in multiple fora. In the past, when there has been some security issue, I have posted in different fora, and the knowledge derived has been phenomenal to solve the issue. I appreciate and respect that others may have a different point of view.

In future, if I cross-post in these forums I shall transparently provide the links to the extent possible. To clarify, if I post in Forum 'A' first, Forum 'B' next, and Forum 'C' last, my post in Forum 'A' will not have the links to Forums 'B' and 'C' till I post in the last two. So, I shall get back to Forum 'A' and edit my OP, to provide 'B' and 'C' links, and so on. Hope this is ok, and within the rules.