Forum Discussion
excel formula help needed please
I have set up a formula to look for dangerous goods. The formula is set up in sheet 1 in column K and reads =IF(ISNUMBER(MATCH(E2,$K$2:$K$1688,0)),"GDG","N/A"). In column E is the material and column...
Hi, I'm not sure if there is any alternative keeping the same structure....I'm going to propuse to you an option to add columns in Sheet 1.
1) Add a column B. On that contactenate Order numbre & DG Formula(A1&M1)
2) In the vlookup of sheet 2 introduce, as lookup value, contatenation of these two colunms =VLOOKUP(B2&"GDG";sheet1!B$1:M$179;11FALSE). Column 11 return dangerous product
I hope it works for you.
Regards
https://www.upwork.com/freelancers/~01cf0fc8446b00f44c