Excel 2007 : Vlookup

[Bilal Sadiq]

Hi,
I am working on two sheets; in the first sheet I have a table with country names in column A (like Afghanistan AT Mobile) and rates in column B. In the second sheet i only have country names in column A. In column B I am trying to use Lookup function to match country names in both the sheets (and find exact text) and return the corresponding rates from the first sheet. Each time it returns #NA. Your help and suggestions will be highly appreciated.

Bill

[solnajeff]

HI

You could use INDEX and MATCH to get the same result, I have attached an example for you.

regards

Jeff

[teylyn]

Each time it returns #NA

This means that the lookup value cannot be found in the lookup table. This is probably due to the values not being truly the same. Check a value that you think should be matched and see if it has leading or trailing spaces in one but not in the other.

Then either take measures to remove the spaces if they are in the lookup table, or use TRIM(lookup_value) in the Vlookup formula if the spaces are in the lookup value.

hth