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.
Hello,
int the previous post I attached a file to solve the issue. However with you new setup you can use the attached file.
Thank you. In the previous message I didn't see any change in the formula and it was not working in your attachment. This one appears to be working fine now. Appreciate your help!