VLOOKUP

  • Thread starter Thread starter ku
  • Start date Start date
K

ku

Hi, I'm using vlookup to compare two lists. One is an
Excel spreadsheet originally in 2.1 format but I have
saved to 2000. The other is copied/pasted from Access and
I have also saved this one to Excel 2000 format. When I
do the VLOOKUP I get #N/A for every comparison. However,
if I select a cell from either (though it seems it works
more consistently with the data copied from Access) and
press F2 then enter (I do not enter any data), the VLOOKUP
works. Thanks in advance for any help!
 
it happens with a lot of database retreives. here is what
you do...
put 1 in any blank cell. then copy it, select your data
and PasteSpecial, select Multiply and click ok.

That should do it
good luck
 
Back
Top