Thanks - the second one worked for me!

"Aladin Akyurek" wrote:


na Wrote:
In the first sumproduct Column G has the following:
=E40*(VLOOKUP(F40,Airfare,2,FALSE))

in the second sum product columan N has:
=VLOOKUP(M2,Airfare,3,False)...

If Airfare is sorted on its first column, use the faster:

=E40*IF(VLOOKUP(F40,Airfare,1,1)=F40,VLOOKUP(F40,A irfare,2,1),0)

Otherwise, you have to resort to costly...

=E40*IF(ISNA(VLOOKUP(F40,Airfare,2,FALSE)),0,VLOOK UP(F40,Airfare,2,FALSE))


--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165
View this thread: http://www.excelforum.com/showthread...hreadid=274352