if(vlookup,vlookup) maybe?

[EcomTom]

I dont know if this is possible or not. I need to reference two columns in a vlookup to create a table. This seems to be an if statement with a vlookup inside a vlookup referencing the same array. Please see the image below for an example.

 

[adam087]

Have you considered using a pivot table? That'd be the best solution for me I think.

Otherwise...
[H3] =SUMPRODUCT(--($G3=$A$3:$A$8), --(H$2=$B$3:$B$8), $E$3:$E$8)/SUMPRODUCT(--($G3=$A$3:$A$8), --(H$2=$B$3:$B$8))

Regards
Adam

 

[EcomTom]

I think the formula is perfect. I have to test it on the full project now.

The idea is to have the vlookup done for 5000 rows and 15 or so columns referecing 4 tabs of data that is compiled throughout the month. Then all I have to do is drop in the SKU to get the desired result.

Thanks for the quick reply. It took me longer to do the post then to get the reply.

 

[zdodson]

How were you able to upload a picture into the thread? I am trying to do it the way I know how, but it doesn't seem to be working.

 

[adam087]

I think the formula is perfect. I have to test it on the full project now.

The idea is to have the vlookup done for 5000 rows and 15 or so columns referecing 4 tabs of data that is compiled throughout the month. Then all I have to do is drop in the SKU to get the desired result.

Thanks for the quick reply. It took me longer to do the post then to get the reply.

No problem. Thanks for the feedback. I would recommend checking out the Pivot Tables as well as they might help you, if not with this, then with something else.

Regards
Adam

 

[EcomTom]

How were you able to upload a picture into the thread? I am trying to do it the way I know how, but it doesn't seem to be working.

<p> I upload the image to Photobucket.com then take the url provided and insert it through the "Insert Image" button</p>

 

[EcomTom]

No problem. Thanks for the feedback. I would recommend checking out the Pivot Tables as well as they might help you, if not with this, then with something else.

Regards
Adam

<p> Pivot tables wont produce the desired result. I used your formula and normal vlookup to create a tool that I give to other people at work so I wont have to continually make the same data query's throughout the month. The tool references tabs in the excel doc that contain multiple reports that multiple people do throughout the month. I do use Pivot tables to create the reports that feed the reference tool I created with your formula. This tool will prevent the document from having to be sent to many different people so they can add their data. The elimination of the email chain will create a quicker response time for the document purpose. </p>

Thanks again for your help

 

[adam087]

Pivot tables wont produce the desired result. I used your formula and normal vlookup to create a tool that I give to other people at work so I wont have to continually make the same data query's throughout the month. The tool references tabs in the excel doc that contain multiple reports that multiple people do throughout the month. I do use Pivot tables to create the reports that feed the reference tool I created with your formula. This tool will prevent the document from having to be sent to many different people so they can add their data. The elimination of the email chain will create a quicker response time for the document purpose.


Thanks again for your help

Good times. Glad you've got a solution that works

Regards
Adam