Help with Price Table

[dayeez]

I have a price table with about 70,000 line items (some lines are duplicates).
There are about 12 columns each with different qualities such as item name, size, thickness, price and etc.
I've been building this table in excel and just importing it into Access for the time being.

When a customer sends me an order, I'd like to be able to look up the items in my price table (matching across multiple columns) and automatically return the price for each item.

Where do I start? What do I need? I literally have no idea where to even begin and have not had much luck trying to google my problem.

Any help or even just pointing me in the right direction is much appreciated!

So far, I've been using the following formula....

=LOOKUP(2,1/($A$1:$A$60000=D1),$B$1:$B$60000)

With A5:A60000 = price list concatenate so all columns in 1
D1 = item I'm searching for
B1:B60000 = prices for items

The only thing is that this is very labor intensive. Was wondering if anyone knew a quicker faster way to do this. Maybe something in Access?

 

[skywriter]

I'd be willing to help you, but I need to see the spread sheet. If you are uncomfortable with this maybe you could make a copy, delete the data, leave the headers, put in a few lines of fake data and then tell me what you want to see specifically. I'm unclear how to help you just by your description.

 

[Michael M]

Well, you could use VLOOKUPS for each required item, but that's only a guess at this stage.
As skywriter suggested, some more information would be required.
Also with 70,000+ lines you might be better off using an Access query / Report