A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

VLOOKUP and IF together



 
 
Thread Tools Display Modes
  #1  
Old April 23rd, 2010, 03:01 PM posted to microsoft.public.excel.worksheet.functions
FR[_2_]
external usenet poster
 
Posts: 2
Default VLOOKUP and IF together

Hi,

I trying to create a formula for this.

Sheet 1 - where the formula is created
Column A - name part-number
Column B - name wholesaller
Column C - price of that part-number in that wholesaller

Sheet 2 - where info is
Column A - name wholesaller
Column B - name part-number
Column C - price for that part-number in that wholesaller
Note: the same part-number has different prices, depending on the wholesaller

Sheet 1
Column A - name part-number - here is value that shall be look up for in
other sheet, that I shall call Sheet 2. In the Sheet 2 the same part-number
will appear 5 times in 5 different rows, associated to 5 different
wholesellers with five different prices
Column B - name wholesaller - here I insert the name of the wholesaller
Column C - value of the part-number in the specified wholesaller - here is
where I insert the formula ( is it a IF+VLOOKUP ? ) where The price looked
for is the one in Sheet 2, that is associated with the specific whosaller I
inserted on Columnn B

I hope I was clear.

thanks everyone!
cheers from Portugal, Lisboa

Fernando
  #2  
Old April 23rd, 2010, 03:16 PM posted to microsoft.public.excel.worksheet.functions
Don Guillett[_2_]
external usenet poster
 
Posts: 607
Default VLOOKUP and IF together

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"FR" wrote in message
...
Hi,

I trying to create a formula for this.

Sheet 1 - where the formula is created
Column A - name part-number
Column B - name wholesaller
Column C - price of that part-number in that wholesaller

Sheet 2 - where info is
Column A - name wholesaller
Column B - name part-number
Column C - price for that part-number in that wholesaller
Note: the same part-number has different prices, depending on the
wholesaller

Sheet 1
Column A - name part-number - here is value that shall be look up for in
other sheet, that I shall call Sheet 2. In the Sheet 2 the same
part-number
will appear 5 times in 5 different rows, associated to 5 different
wholesellers with five different prices
Column B - name wholesaller - here I insert the name of the wholesaller
Column C - value of the part-number in the specified wholesaller - here is
where I insert the formula ( is it a IF+VLOOKUP ? ) where The price looked
for is the one in Sheet 2, that is associated with the specific whosaller
I
inserted on Columnn B

I hope I was clear.

thanks everyone!
cheers from Portugal, Lisboa

Fernando


  #3  
Old April 23rd, 2010, 04:21 PM posted to microsoft.public.excel.worksheet.functions
FR[_2_]
external usenet poster
 
Posts: 2
Default VLOOKUP and IF together

Hi Don,

thank you for your quick reply.

I have just sent to you the info.

Fernando

"Don Guillett" wrote:

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"FR" wrote in message
...
Hi,

I trying to create a formula for this.

Sheet 1 - where the formula is created
Column A - name part-number
Column B - name wholesaller
Column C - price of that part-number in that wholesaller

Sheet 2 - where info is
Column A - name wholesaller
Column B - name part-number
Column C - price for that part-number in that wholesaller
Note: the same part-number has different prices, depending on the
wholesaller

Sheet 1
Column A - name part-number - here is value that shall be look up for in
other sheet, that I shall call Sheet 2. In the Sheet 2 the same
part-number
will appear 5 times in 5 different rows, associated to 5 different
wholesellers with five different prices
Column B - name wholesaller - here I insert the name of the wholesaller
Column C - value of the part-number in the specified wholesaller - here is
where I insert the formula ( is it a IF+VLOOKUP ? ) where The price looked
for is the one in Sheet 2, that is associated with the specific whosaller
I
inserted on Columnn B

I hope I was clear.

thanks everyone!
cheers from Portugal, Lisboa

Fernando


.

  #4  
Old April 23rd, 2010, 07:50 PM posted to microsoft.public.excel.worksheet.functions
Don Guillett[_2_]
external usenet poster
 
Posts: 607
Default VLOOKUP and IF together


'=SUMPRODUCT((Sheet2!$B$2:$B$1000=A2)*(Sheet2!$A$2 :$C$1000=B2)*Sheet2!$C$2:$C$1000)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"FR" wrote in message
...
Hi Don,

thank you for your quick reply.

I have just sent to you the info.

Fernando

"Don Guillett" wrote:

If desired, send your file to my address below. I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"FR" wrote in message
...
Hi,

I trying to create a formula for this.

Sheet 1 - where the formula is created
Column A - name part-number
Column B - name wholesaller
Column C - price of that part-number in that wholesaller

Sheet 2 - where info is
Column A - name wholesaller
Column B - name part-number
Column C - price for that part-number in that wholesaller
Note: the same part-number has different prices, depending on the
wholesaller

Sheet 1
Column A - name part-number - here is value that shall be look up for
in
other sheet, that I shall call Sheet 2. In the Sheet 2 the same
part-number
will appear 5 times in 5 different rows, associated to 5 different
wholesellers with five different prices
Column B - name wholesaller - here I insert the name of the wholesaller
Column C - value of the part-number in the specified wholesaller - here
is
where I insert the formula ( is it a IF+VLOOKUP ? ) where The price
looked
for is the one in Sheet 2, that is associated with the specific
whosaller
I
inserted on Columnn B

I hope I was clear.

thanks everyone!
cheers from Portugal, Lisboa

Fernando


.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:45 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.