Replicate Excel Table

[LEXCERM]

Hi,

I have a table in Excel with number of prints along the top and postcodes down the side (see example, below):-

Prints..1....2.....3.....4....5
AA....£1...£2...£3...£4...£5
AB....£2...£3...£4...£5...£6

I use VLOOKUP and MATCH forumlas to return the results.

How would I achieve something similar in Access. Would this be the table structure:

P'Code...Prints....Cost
AA........1..........£1
AA........2..........£2 etc

Thanks in advance.

 

[plog]

Yes, that's it.

 

[LEXCERM]

Many thanks.