View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Enrique Enrique is offline
external usenet poster
 
Posts: 22
Default vlookup missing link

Hello,
I have Sheet 1 with 5 columns with data and Sheet2 (copy of Sheet1 updated)
I wrote in Sheet2 (to verify that all the units are in sheet2 from sheet1,
perharps I may delete some) to do this, I insert a column to the LEFT next to
the units verifying (e.g. N14555) ...=vlookup(B7,Sheet1!$A$7:$E$460,2,FALSE)
to give me the data from Sheet1 and match that unit in Sheet2, simple right?
well ...not working, I tried to the RIGHT column and nothing, I tried
changing the Units from N14555 to read just 14555, and N/A nothing.

Anybody help,
I will appreciate :)

D- Workalcholic