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
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,794
Messages
5,833,732
Members
430,228
Latest member
Normano

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top