Forum Discussion
Autopopulate from series of Drop Down Menus
Thank you so much for your reply.
So if I were to use that formula, my drop down menus and look up are on sheet1,
while the table and part numbers are on sheet3.
The drop down menus are A2, B2, C2 and D2.
The table is A14:A94,B14:B94, C14:C94, and D14:D94
So should the formula look like...
{=INDEXSheet3!(F14:94, MATCH(Sheet1!A2&B2&C2&D2, Sheet3!A14:A94&B14:B94&C14:C94&D14:D94, 0) )}
You placed "Sheet3!" on the wrong side of the "(", but without actually testing the following formula, it looks correct, assuming your part numbers are in column F of Sheet3.
{=INDEX(Sheet3!F14:94, MATCH(Sheet1!A2&B2&C2&D2, Sheet3!A14:A94&B14:B94&C14:C94&D14:D94, 0) )}
Note that the curly brackets {...} are applied by using CTRL+SHIFT+ENTER to enter the formula as an array formula.