Hello
I am having trouble doing a VLOOKUP.
I have two tabs
On each tab, I have one coulmn.
The data on Both tabs are formated identically. Text arial 10
They are both sorted in ascending order
Here is how I do my VLOOKUP
=VLOOKUP(Spicework!A1;Caro!1:65536;2;FALSE)
On a third tab I want to see the the computer that are in both lists. When I do my VLOOKUP I get #NA or #REF. What am I doing wrong?
Thank you for any light you can shed.
tab 1 - Computer1
abc-053507
abc-053519
abc-053520
abc-053524
abc-053525
abc-053548
abc-053549
abc-053553
abc-053554
tab 2 -Computer2
abc-003211
abc-053519
abc-053549
abc-053556
abc-058528
abc-058556
abc-058558
abc-058611
abc-058633
abc-071027
abc-071095
abc-071228
abc-119003
abc-119009
abc-119046
abc-119059
abc-119062
I am having trouble doing a VLOOKUP.
I have two tabs
On each tab, I have one coulmn.
The data on Both tabs are formated identically. Text arial 10
They are both sorted in ascending order
Here is how I do my VLOOKUP
=VLOOKUP(Spicework!A1;Caro!1:65536;2;FALSE)
On a third tab I want to see the the computer that are in both lists. When I do my VLOOKUP I get #NA or #REF. What am I doing wrong?
Thank you for any light you can shed.
tab 1 - Computer1
abc-053507
abc-053519
abc-053520
abc-053524
abc-053525
abc-053548
abc-053549
abc-053553
abc-053554
tab 2 -Computer2
abc-003211
abc-053519
abc-053549
abc-053556
abc-058528
abc-058556
abc-058558
abc-058611
abc-058633
abc-071027
abc-071095
abc-071228
abc-119003
abc-119009
abc-119046
abc-119059
abc-119062