Should i use Lookup or Vlookup to reference a table?

[Sprackers]

I sell vegetables to a range of clients. All clients have different charges for different vegetables.



My first table is all the vegetables down the left hand side and all the clients along the top with all the charges per item filled in the main body of this table.




My order entry sheet i put in the vegetable, then the client, then the quantity, and I want the last cell to calculate the charges by referencing my veg/client/chages table and multiply it by the quantity i have put in.



I know this is simple but I have looked everywhere and cant find how to do it?



Any help will be really appreciated

 

[steve the fish]

You could use something like this:

=INDEX($A$1:$J$10,MATCH(L1,$A$1:$A$10,0),MATCH(M1,$A$1:$J$1,0))

where the table is in A1:J10. The vegetables in A1:A10. The client in A1:J1. The vegaetable to search for in L1 and the client in M1.

 

[Sprackers]

You could use something like this:

=INDEX($A$1:$J$10,MATCH(L1,$A$1:$A$10,0),MATCH(M1,$A$1:$J$1,0))

where the table is in A1:J10. The vegetables in A1:A10. The client in A1:J1. The vegaetable to search for in L1 and the client in M1.

Cheers Steve the Fish, I'm going to go away now and try and figure it out.

Many thanks