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
|