How to create a logical search?

[Jermdog]

This is what I would like to be able to do. I would've searched the forums better, but since I can't explain what formula I need, it's hard to describe.

Anyways, I have multiple tabs set up, and each one contains multiple data. The tabs represent parts of a computer (like Hard Drive, Motherboard, etc.), and each sheet has different parts in that category. What I would like to be able to do is basically put a 'check mark' next to the piece I want to put in the assembly, and have the cost of the part show up on my Assembly tab.

For example.

Hard Drive (Tab)

250GB / $69.99
500GB / $89.99 X
750GB / $99.99

Assembly (Tab)

Hard Drive / $89.99


Thank you in advance

[darkyam]

Could you please post your workbook, with dummy data if necessary? It will be much easier to give you the exact formula you need, and we might even be able to get it to drag down so it applies to each part without customization.

[Jermdog]

Here you go, let me know if this works for you

[protonLeah]

I was expecting more data, but this in the price cell on the create sheet will return the price of item with a "1"

Please Login or Register  to view this content.

[Jermdog]

I had to rewrite the code to

=LOOKUP(1,Motherboard!E3:E7,Motherboard!D3:D7)

for the right columns, but THANK YOU very much!

Now, I do have one other question if you could help me, and I hope I don't lose you. I apologize if I do. There are some pieces of the computer that won't work with others, like if a motherboard (Low End) only takes up to a 95W processor. I want to make it so it comes up saying that I can't choose a processor that's higher than 95W. If need be, I'll try to create the sheet so you can get a better idea.