That formula doesn't look right to me. Did you check the arguments in Help?

Unless this is an array formula, $F$5:$F$17*1000 isn't legal. And the 3rd
argument is supposed to be a row number, like 1, 2, 3, etc.

If the problem is that the numbers in the table have been divided by 1000 when
compared with your lookup value, I'd do it like this:

=HLOOKUP(B5*F5/1000,$F$5:$F$17,<some number between 1 and 13 here>,0)



On Sat, 19 Feb 2005 20:39:02 -0800, Sharon <Sharon@discussions.microsoft.com>
wrote:

>Biff,
>I tried a new function HLookup-here it is:
>
>=HLOOKUP(B6*F5,$F$5:$F$17*1000,$F$5:$F$17,0) and the formula on B8 is my
>answer of 620 but after I select "Enter" the cell shows N/A
>
>"Biff" wrote:
>
>> Hi!
>>
>> What does your formula look like?
>>
>> Try this:
>>
>> =B3*IF(ISNUMBER(VLOOKUP(B2,D2:F5,3,0)),VLOOKUP
>> (B2,D2:F5,3,0),0)
>>
>> Biff
>>
>> >-----Original Message-----
>> >Hello,
>> >
>> >I am trying to use a lookup function to calculate the
>> following:
>> >
>> >To determine the amount of foreign currency due a custorm
>> >My Excel looks like this:
>> >
>> >Columns A & B
>> >Country traveling to: England
>> >US Dollars to exchange: $1,000.00
>> >Country's currency: Pound
>> >Amount due customer:
>> >
>> >Columns D, E, & F
>> >
>> >Country Currency Exchange Rate
>> >England Pound 0.6200
>> >France Euro 0.9525
>> >Germany Euro 0.9526
>> >Canada Dollar 1.5603
>> >How do I set up the calculation to calculate the foreign
>> currency the
>> >customer is due and that this figure appears in cell B8
>> labeled "Amount due
>> >customer". The first one shoulw list $620, but my lookup
>> function gives me
>> >#N/A...please hlep
>> >
>> >
>> >.
>> >
>>