HLOOKUP problem...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

silas - 13 Jun 2007 05:24 GMT

I'm having a problem getting HLOOKUP to work where my data is on another
sheet and the table array comes before the lookup value. For instance, on
sheet2 I have a list of names in column G and money amounts in column F. So
on sheet1 I coded: =HLOOKUP(Sheet2!"Bob Smith",F12:F20,1,FALSE). I Want to
get the money amount from column F that corresponds with Bob Smith in Column
G but it's not working.

I'd appreciate any assistance.

Thanks.

silas

Reply to this Message

T. Valko - 13 Jun 2007 06:10 GMT

Try this:

A1 = Bob Smith

=INDEX(Sheet2!F$12:F$20,MATCH(A1,Sheet2!G$12:G$20,0))

Or, if you want to hardcode it into the formula:

=INDEX(Sheet2!F$12:F$20,MATCH("Bob Smith",Sheet2!G$12:G$20,0))

Biff

> I'm having a problem getting HLOOKUP to work where my data is on another
> sheet and the table array comes before the lookup value. For instance, on
[quoted text clipped - 8 lines]
>
> silas

Reply to this Message

silas - 13 Jun 2007 22:05 GMT

Thank you very much. The Index function did the trick.

silas

> Try this:
>
[quoted text clipped - 20 lines]
>>
>> silas

Reply to this Message

T. Valko - 13 Jun 2007 22:58 GMT

You're welcome. Thanks for the feedback!

Biff

> Thank you very much. The Index function did the trick.
>
[quoted text clipped - 24 lines]
>>>
>>> silas

Reply to this Message