Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
removing automatic link | Excel Discussion (Misc queries) | |||
link excel database? | Excel Discussion (Misc queries) | |||
Finding a Problem Link in Excel | Excel Discussion (Misc queries) | |||
In Excel 2003, under the File menu the Permission link is missing | Excel Worksheet Functions | |||
carrying a hyper link when using the vlookup function | Excel Worksheet Functions |