HLOOKUP problem...

[T. Valko]

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

 

[silas]

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

 

[T. Valko]

You're welcome. Thanks for the feedback!

Biff

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

silas

 

[silas]

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

silas