V-Look up copy problem-PLEASE HELP

S

Sekhar

Hi I am trying to look-up the expenses based on the ID on the person.

I used the formula "=VLOOKUP(A2,'Base Data'!$A$2:$E$489,5,FALSE)" whose
result is 183. When I copy the same in the col I am getting the result as
"183" in all the cells in the col. Unless I actually do F2 and enter, the
actual value is not returned. I have sorted both the 'lookup value' col & 1st
col in 'Table array' by ascending order, but still persisting with the
problem.

ID Expenses
10740_IN 183
11083_IN 183
11518_IN 183
11921_IN 183
12060_IN 183
12449_IN 183
13084_IN 183
13369_IN 183
13529_IN 183

Can somebody assist. Hope I have given the full description of my problem.
Thanks in advance.
 
S

Stefi

Is Tools>Options>Calculation set to Automatic?

Regards,
Stefi

„Sekhar†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 lookup problem continuing ... 3
v look up 2
Function or Sub to help with text string 5
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
Index and Match 8
Sum Products with VLOOKUP 3
Index, Match, Lookup, Vlookup or Combination? 1
Please can you help me 7

Top