lumineers01
New Member
- Joined
- Dec 7, 2013
- Messages
- 44
I'm having problem with the formula I'm using in Excel.
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... I need the formula to return the whole row of the identifier (Code1, 2 etc..).
Thanks!
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... I need the formula to return the whole row of the identifier (Code1, 2 etc..).
Thanks!
Last edited: