If got the following cell:
=VLOOKUP(A2&K1,errors,3, FALSE)
I'm trying to read to colums (A2 = store number and K1 = Error Code). The worksheet errors has the store number broke down by multiple codes listed vertically and I'm trying to bring them into another worksheet horizontally. I think I'm close but I keep getting a value of #NA. Any suggestions would be much appreciated. Thanks.
=VLOOKUP(A2&K1,errors,3, FALSE)
I'm trying to read to colums (A2 = store number and K1 = Error Code). The worksheet errors has the store number broke down by multiple codes listed vertically and I'm trying to bring them into another worksheet horizontally. I think I'm close but I keep getting a value of #NA. Any suggestions would be much appreciated. Thanks.