criteria

duckworj

New Member
Joined
Mar 8, 2005
Messages
27
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) :cry:

Thanks for your help
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

rs2k

Well-known Member
Joined
Aug 15, 2004
Messages
1,413
Can you post a sample of how the list is laid out. It sounds like a job for VLOOKUP.

Colin.
 

duckworj

New Member
Joined
Mar 8, 2005
Messages
27
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

New Member
Joined
Mar 8, 2005
Messages
27
Hi there everyone! :biggrin:

Has anyone got any ideas for me!

I really don't know what to do

Help! :) :)

jane
 

Watch MrExcel Video

Forum statistics

Threads
1,118,531
Messages
5,572,723
Members
412,482
Latest member
arooshrana2
Top