Lets say on one spreadsheet I have my actual sales:

Column A Customer Part Sales
=B1&C1 Cisco A $W

=B2&C2 Nortel A $X
=B3&c3 Cisco B $Y
=B4&C4 Nortel B $Z

Column G Colmn H Column I
Cisco A =G1&H1



Cell F1
=VLOOKUP(I1,A1:D4,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: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=516461