| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
compare and return a value from another worksheet
I have a workbook with two worksheets ... Customer (A) & New Sales Price (B).
Worksheet A has a column listing item numbers and in a corresponding column the current sales price of the item. Worksheet B has a complete listing of all items and their corresponding new sales price. Worksheet A does not include all the items on B but needs a column listing the new sales price for only items that are on A. For example: Worksheet A Col A Col B Col C 1 100001PDW $0.40 New Price from WS B matching 100001PDW 2 100203PD $1.48 New Price from WS B matching 100203PD 3 100100 $0.22 New Price from WS B matching 100100 I want to use Worksheet B for multiple customer comparisons and will analyze and explain impacts of the price change for each customer. So WS B is my database with all items and their corresponding new price. Hopefully this is enough info -- Thanks aplenty Mike |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
compare and return a value from another worksheet
Hi,
You should use the VLOOKUP() function in column C =vlookup(A1,sheet 2 range,2,0). Please read up more on the VLOOKUP() function -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Mike" wrote in message ... I have a workbook with two worksheets ... Customer (A) & New Sales Price (B). Worksheet A has a column listing item numbers and in a corresponding column the current sales price of the item. Worksheet B has a complete listing of all items and their corresponding new sales price. Worksheet A does not include all the items on B but needs a column listing the new sales price for only items that are on A. For example: Worksheet A Col A Col B Col C 1 100001PDW $0.40 New Price from WS B matching 100001PDW 2 100203PD $1.48 New Price from WS B matching 100203PD 3 100100 $0.22 New Price from WS B matching 100100 I want to use Worksheet B for multiple customer comparisons and will analyze and explain impacts of the price change for each customer. So WS B is my database with all items and their corresponding new price. Hopefully this is enough info -- Thanks aplenty Mike |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
compare and return a value from another worksheet
Ashish:
Works great ... greatly appreciate your response and expertise. -- Thanks aplenty Mike "Ashish Mathur" wrote: Hi, You should use the VLOOKUP() function in column C =vlookup(A1,sheet 2 range,2,0). Please read up more on the VLOOKUP() function -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Mike" wrote in message ... I have a workbook with two worksheets ... Customer (A) & New Sales Price (B). Worksheet A has a column listing item numbers and in a corresponding column the current sales price of the item. Worksheet B has a complete listing of all items and their corresponding new sales price. Worksheet A does not include all the items on B but needs a column listing the new sales price for only items that are on A. For example: Worksheet A Col A Col B Col C 1 100001PDW $0.40 New Price from WS B matching 100001PDW 2 100203PD $1.48 New Price from WS B matching 100203PD 3 100100 $0.22 New Price from WS B matching 100100 I want to use Worksheet B for multiple customer comparisons and will analyze and explain impacts of the price change for each customer. So WS B is my database with all items and their corresponding new price. Hopefully this is enough info -- Thanks aplenty Mike |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
compare and return a value from another worksheet
Thank you. Glad I could help
-- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Mike" wrote in message ... Ashish: Works great ... greatly appreciate your response and expertise. -- Thanks aplenty Mike "Ashish Mathur" wrote: Hi, You should use the VLOOKUP() function in column C =vlookup(A1,sheet 2 range,2,0). Please read up more on the VLOOKUP() function -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Mike" wrote in message ... I have a workbook with two worksheets ... Customer (A) & New Sales Price (B). Worksheet A has a column listing item numbers and in a corresponding column the current sales price of the item. Worksheet B has a complete listing of all items and their corresponding new sales price. Worksheet A does not include all the items on B but needs a column listing the new sales price for only items that are on A. For example: Worksheet A Col A Col B Col C 1 100001PDW $0.40 New Price from WS B matching 100001PDW 2 100203PD $1.48 New Price from WS B matching 100203PD 3 100100 $0.22 New Price from WS B matching 100100 I want to use Worksheet B for multiple customer comparisons and will analyze and explain impacts of the price change for each customer. So WS B is my database with all items and their corresponding new price. Hopefully this is enough info -- Thanks aplenty Mike |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare and Return Value | Excel Worksheet Functions | |||
| Compare and Return Results | Excel Discussion (Misc queries) | |||
| Compare Value in Cell 1 to a List, Return Value if Match otherwise Return Null | Excel Discussion (Misc queries) | |||
| compare two spreadsheets and return a value | Excel Worksheet Functions | |||
| How to compare 3 numbers and return value | Excel Worksheet Functions | |||
Linear Mode
