LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11
Default relation between 'items' en 'prices'

Hello,
I am trying to make a Quote-spreadsheet. I have a column with items that i
can choose from a list. Now I want anothor column to get automaticly the
right price for that item out of a list. Do I need a formula that says if the
item in cel 'a' is 'x' than the price in cel 'b' is 'y' ? I am new and don't
now how to solve this. Can anybody help me.
Thanks in advance !
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
#REF problems in a relation between worksheets Jens Palacios Neffke[_2_] Excel Discussion (Misc queries) 1 April 13th 07 09:37 PM
relation equation between two columns jk Excel Worksheet Functions 3 March 19th 07 09:25 AM
how can i find the relation between x & y in chart nadir Charts and Charting in Excel 2 March 16th 07 02:33 AM
Use a multiplier to change List Prices to Net prices Dangada Excel Worksheet Functions 1 July 6th 05 06:31 AM
Cell relation ships. Slukes Excel Discussion (Misc queries) 3 April 2nd 05 12:47 PM


All times are GMT +1. The time now is 11:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"