Forum Discussion
3 way lookup using index with match
Please check the attached file.
Ok, I attached the file. I highlighted in red the culprits that are causing my problems on the product lists tab. Currently it works... except it is pulling in the 1st GTIN# it comes to, not the one that goes with the Brand/Description in B5/B7
Hello,
ths will do the trick
=OFFSET('Product list'!$A$1;MATCH(1;INDEX((TRIM($B$7)=INDEX(TRIM('Product list'!E1:$E$35);;))*(UPPER(RIGHT($B$5;LEN($B$5)-3)&" "&LEFT($B$5;3))='Product list'!B1:$B$35);;);0)-1;MATCH($G$3;'Product list'!$A$1:$AE$1;0)-1;1;1)
Hi there. I think you are missing something. I am getting this error when I try it.
Please check the attached file.
Thanks for the info. Had some problems getting it to work the other day. Got busy and was just able to get back to this today. Not sure what I was doing the other day, but it worked great today. Thanks again.