I'm having problem with the formula I'm using in Excel. Since I can't add images here, here's a link:

Here's the link to the sheet, where Sheet 1 is the source data: https://www.dropbox.com/s/ispzi99u884ic9i/New%20Microsoft%20Excel%20Worksheet%20%282%29%20-%20Copy.xlsx?dl=0

I'm using this formula: =VLOOKUP(A2,Sheet1!A1:D1000,2,FALSE)

As of now, I can enter value in column A of Sheet 1 and it will return the whole row containing that. The problem is, when I try to enter "Code1", I notice it doesn't return any data. Can someone explain why that happens? I'm an Excel noob...

`=VLOOKUP("Code1",Sheet1!$A$1:$D$1000,2,FALSE)`

– Brian Folan Nov 2 '14 at 16:08