Re: Lookup Function

Tech-Archive recommends: Fix windows errors by optimizing your registry

=HLOOKUP($C$4,INDIRECT("'" & C1 & "'!A4:C7"),$C$3,FALSE)

Try this:

=HLOOKUP($C$4,INDIRECT("'" & C1 & "'!A4:C7"),MATCH($C$3,INDIRECT("'" & C1 &
"'!A4:A7"),0),0)

Biff

"kmwhitt" <kmwhitt@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:87DFD4EB-43A9-4242-87FB-EB6ECD15E135@xxxxxxxxxxxxxxxx
Thanks, Biff....

I can get the function to work when I use a number, but not when I am
referencing the contents of a cell.

For example:

=HLOOKUP($C$4,INDIRECT("'" & C1 & "'!A4:C7"),"$C$3",FALSE)

I've also tried:

=HLOOKUP($C$4,INDIRECT("'" & C1 & "'!A4:C7"),$C$3,FALSE)

and

=HLOOKUP($C$4,INDIRECT("'" & C1 & "'!A4:C7"),"Stain Only",FALSE)
where Stain Only is a column header in my table.

This works:

=HLOOKUP($C$4,INDIRECT("'" & C1 & "'!A4:C7"),2,FALSE)
but does not accomplish what I want.

Please advise. Thanks again,

Kevin

"Biff" wrote:

They are text, so I don't think HLOOKUP or VLOOKUP will help. Correct?

No, you can use TEXT in lookup tables. Try it!

Biff

"kmwhitt" <kmwhitt@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4E63163D-EA4E-425A-9DBD-193E38660243@xxxxxxxxxxxxxxxx
I have a simple table with 4 rows and 3 columns on one work*** -
A4:C7.
On
another work*** I would like to lookup a value from the table and
have
it
show up in cell F2. The column and row headings are NOT numbers. They
are
text, so I don't think HLOOKUP or VLOOKUP will help. Correct? What
function
is best suited to accomplish this?

Thanks,

Kevin






.

Quantcast