Forum Discussion
Solved
3 way lookup using index with match
We are working on a form that auto-populates info from a spreadsheet when info is entered. I need cell H3 to populate info based on info from cell B5 ('Product list'!B2:BZ2999,MATCH(BASF!B5,'Product...
Please check the attached file.
Hi
It would be easier if you provide a sample Excel file to avoid random creation of the desired layout.
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.
