criteria

duckworj

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

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
Can you post a sample of how the list is laid out. It sounds like a job for VLOOKUP.

Colin.
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,211,434
Messages
6,101,823
Members
447,758
Latest member
jojo3strada

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
Back
Top