Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup missing link
....=vlookup(B7,Sheet1!$B$7:$E$460,2,FALSE)
instead of A7, since it is a copy of sheet1, sheet 2 will list B7 also in B7 ( Column B, therefore you can't search column A for it) ....=vlookup(B7,Sheet1!$A$7:$E$460,2,FALSE) =VLOOKUP(B7,Sheet1!$B$7:$E$460,2,FALSE) "Enrique" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup missing link
I did manage to change my question into more easy and it work!
Thank you for your help. :) I hope you get a lot of fishes. -- D Workalcholic "ufo_pilot" wrote: ...=vlookup(B7,Sheet1!$B$7:$E$460,2,FALSE) instead of A7, since it is a copy of sheet1, sheet 2 will list B7 also in B7 ( Column B, therefore you can't search column A for it) ...=vlookup(B7,Sheet1!$A$7:$E$460,2,FALSE) =VLOOKUP(B7,Sheet1!$B$7:$E$460,2,FALSE) "Enrique" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |