Hi guys
I have 2 worksheets in my excel file, the All standards worksheet has a large table of items referenced as AllStandards in it and the Doable sheet has a smaller table of selected data referenced as Doable. In the Doable sheet I was trying to create a system where I can input a specific ID number in the B column and in the C column, a vlookup or index match formula would search over in the All Standards sheet and get the description relating to that ID number. I tried both the formula methods but I keep getting returned a #N/A error as you'll be able to see in the C2 and C3 cell in the Doable sheet. Could someone please help me with this? I have no idea what I'm doing wrong. Thanks
Bookmarks