criteria

[duckworj]

Hi there Everyone...

Another one has me baffled

I have a list of items which each have a description, date, a score and a price attached.
This list is stored on a seperate spreadsheet at the moment, which is being updated all the time.

for Example...

item "300" could be available on 01/01/05 or 01/09/05. Its
Both dates would result in a score of 15 and its title would stay the same.
However, the prices would change. The item on the 01/01/05 would cost say £300 but the item on the 01/09/05 would cost £500.

I need to be able to tie up the information from one spreadsheet to another...

I want to input the item number on the spreadsheet and the information relating to the title and score would come up automatically. I would then like it to give me an option from the dates available and then automatically work out the cost...

At the moment i have about 400 items...(ARRGHHH)

Thanks for your help

 

[rs2k]

Can you post a sample of how the list is laid out. It sounds like a job for VLOOKUP.

Colin.

 

[duckworj]

Hi there

Each item is set out like this in one row on a spreadsheet called "list"

Item score title date cost
300 15 drawing 01/09/05 £500
300 15 drawing 01/01/05 £300

I then have a main database which records all information about enquiries and bookings etc.

I want to be able to put the item number iinto the main database and then the main database put in the score and title. I would also like it to give me the optiions available for the date (so that I could control the quality) and then I would like it to put in the price (so that we are not misquoting)

Hope this helps#

Jane

 

[duckworj]

Sorry I should have said 1 row per item...

 

[duckworj]

Hi there everyone!

Has anyone got any ideas for me!

I really don't know what to do

Help!

jane