Vlookup and #N/A error

  • Thread starter Thread starter hrsdias
  • Start date Start date
H

hrsdias

I keep getting this problem and always find very hard to overcom
without loosing much time and efforts. I have one spreadsheet A wit
vlookup formulas that are supposed to retrieve the info I want (prices
which are located in another spredsheet (B). The idea is to insert
reference in spreadsheet A and the vlookup formula gives me the pric
for that reference. Every year I have prices updates so I copy th
spreadsheet that I am given from my boss with the thousands of ne
prices and paste it to the spreadsheet B. The problem is that once I d
this the vlookup formulas in spreasheet A seems to not recognize th
values I've just pasted in spreadheet B and retrieve no values!
friend of mine once teached me to use a formula to format the cells i
spreadheet B. This is: "=D4&"" (D4 is just an example of a cell - I d
this to every cells). I insert new columns and paste this formula i
there and then I copy and paste the values to the cells where the
should be. Once I do this the vlookup formula starts to work an
retrieve the values that I want but I loose the format of the cells -
have columns which I need to be formated as currency with only 2 decima
places (I get 10!), others that are percentile, and so on. Is there a
easy way to paste the data in spreadsheet B and immediately th
formulas in spreadheet A reterieve the values I want and with th
format I want? Thanks in advance
 
I wish it would be that easy! I tried but it doesn't work. I think
have to format the cells before or after I paste the new values. I jus
don't know how I should do it. Any other suggestions
 
It doesn't do anything. The Vlookup formulas in the spreadsheet A won'
retrieve the values!
 
So what do you see? An error value? What? The formula? Then format the cell
as general and re-enter the formula (F2, ENTER)
"Doesn't do" doesn't exist! Or is there a whole in your screen where look
through?
 
Back
Top