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

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

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

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