Referencing table data in "dropdown" menus

Hi Dalton. Welcome to the forum.

There is a seldom used optional 4th argument in INDEX called [area_num]. It can work well with multiple lookup tables.

Explore this RE: point A).

If this is not helpful I suggest you upload a small sample Excel workbook that will illustrate the key points. Please do not upload pics or screen shots. It saves having to retype data, and I can see the problem(s) in some kind of context. You will also find that you get more and faster responses if you do so.

If you do not know how to upload a file:

To attach a file to your post,

• click “Go Advanced” (next to Post Quick Reply – bottom right),
• scroll down until you see “Manage Attachments”, click that,
• click “Browse”.
• select your file(s)
• click “Upload”
• click “Close window”
• click “Submit Reply”
• be sure to desensitize the data

The file name will appear at the bottom of your reply.

Sorry for my extended delay, I took a break from this project for a while and am just readdressing it now.

Attached are two screenshots of the files, as you can see, I'm creating the calculator to try and populate data based on a criteria of drop-down selections. (Consider if the user were to input in the QTY1 cell, "24", and were to select "1-color" the data would populate to show $1.90)

My big issue now is trying to "lookup" the data in a multi-row&column function... I'm not sure how to perform the function idea of "If you select 1-color, and quantity 'x', then excel will populate data based on that criteria")
I thought about using a VLOOKUP nested in an IF function, but then I couldn't reason with how to specify the row based on quantity...

Originally Posted by FlameRetired

If this is not helpful I suggest you upload a small sample Excel workbook that will illustrate the key points. Please do not upload pics or screen shots. It saves having to retype data, and I can see the problem(s) in some kind of context. You will also find that you get more and faster responses if you do so.

If you do not know how to upload a file:

To attach a file to your post,

• click “Go Advanced” (next to Post Quick Reply – bottom right),
• scroll down until you see “Manage Attachments”, click that,
• click “Browse”.
• select your file(s)
• click “Upload”
• click “Close window”
• click “Submit Reply”
• be sure to desensitize the data

The file name will appear at the bottom of your reply.

Please post a sample workbook.