Forum Discussion
3 way lookup using index with match
Please check the attached file.
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.
Guess I replied too fast. The spreadsheet has 3 areas for drop downs to come up with the GTIN and Item#. The formula you gave appears to work for most HarvXtra (D1 drop down), but it is not working when you choose hvxPRIVATE.LABEL (B5), and variety drop down(B7), or for and Conventional or Roundup.Ready (D1), with any (B5) and (B7) options. It is returning #N/A. The formula you gave is way over my head to be able to figure out where the problem is. I suspect maybe it is too specific somewhere... I attached the spreadsheet with your formulas in for GTIN and ITEM#. I expanded the 'search' parameter from what you had given. The product list tab that is attached, is not the full product list