vlookup not working on bottom cell of column list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using a vlookup function on a list of 30 items in a column
I want my funciton to look at items on worksheet 1 and get the corresponding data from worksheet 2
I also want to get the exact match of value ,so I set the range lookup to FALSE. I sorted the values in ascending order for both workhseet 1 and 2

Here's the problem: my vlookup function works perfectly for item1 thru 29, but displays the #N/A for item 30 (the last cell).I know that I should get a value instead of #N/A because when I go to worksheet 2, I can easly find the value I want for item 30

What can I do to to get my vlookup function to work on all the items of my list; from item 1 to and including item 30

I 'repaired ' the program by going to Help-->Detect and Repair ,but i am still facing the same problem for item 30

I will be gratefull for any help I can get in resolving this urgent matter

Thanks
Sandy M
 
Hi Sandy
first post your current formula
Reason could be that the value in row 30 is formated differently. Check
this with a formula like
=cell_30=cell_with_search_value
this should return TRUE
 
Back
Top