software

I've read a few threads trying to find my answer but they were too
abstract for me to understand.

Lets say on one spreadsheet I have my actual sales:

Customer Part Sales
Cisco A $W
Nortel A $X
Cisco B $Y
Nortel B $Z

I have a second spread sheet with my forecasted sales

Customer Part Sales
Cisco A $??

What I want to do is have a vlookup of the actual sales figure of Part
A. The problem is, I have two criteria. It not only has to be the
sales for Part A, it has to be only Cisco sales for part A when
multiple customers are buying this same part.

So, how do I do a two criteria Vlookup?

-John--
hollister22nh
------------------------------------------------------------------------
hollister22nh's Profile: www.excelforum.com/member.php...oamp;userid=31917
View this thread: www.excelforum.com/showthread...hreadid=516461
Lets say on one spreadsheet I have my actual sales:

Column A Customer Part Sales
=B1amp;C1 Cisco A $W

=B2amp;C2 Nortel A $X
=B3amp;c3 Cisco B $Y
=B4amp;C4 Nortel B $Z

Column G Colmn H Column I
Cisco A =G1amp;H1
Cell F1
=VLOOKUP(I1,A14,4,FALSE)

I concatenated the two cells so they will match, works fine,
you can place those reference cells anywhere
=VLOOKUP Cell I1 which is really CiscoA, looks for CiscoA in the table
and will give you the value $W
Dave--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=516461