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

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

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