vlookup

[rob p]

I need a little help on how vlookup works. I duplicated the worksheet in
help with a range of A4:C12 - called range.

I can see how vlookup evaluates data. BUT, where do I put the
"VLOOKUP(1,range,1,TRUE)" for it to return a value? I tried typing it under
the A4:C12 range. Nothing happens. Where do I see where it equals .946 as in
the sample (Excel 2000). I am missing something.

thanks.

 

[RagDyer]

Are you perhaps missing the equal ( = ) sign ?

=VLOOKUP(1,range,1,TRUE)

Will work *anywhere* in the same worksheet as the table and the named range.

BTW, you did name the range, didn't you?
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I need a little help on how vlookup works. I duplicated the worksheet in
help with a range of A4:C12 - called range.

I can see how vlookup evaluates data. BUT, where do I put the
"VLOOKUP(1,range,1,TRUE)" for it to return a value? I tried typing it under
the A4:C12 range. Nothing happens. Where do I see where it equals .946 as in
the sample (Excel 2000). I am missing something.

thanks.

 

[Debra Dalgleish]

If you're using Excel 97, the example in Help doesn't include an equal
sign at the start of the formula. The formula should be:

=VLOOKUP(1,Range,1,TRUE)

Also, there are some instructions and examples on my web site:

http://www.contextures.com/xlFunctions02.html

 

[Gord Dibben]

rob

Could explain, but easiest is to send you off to Debra Dalgleish'a site where
she has instructions and graphics far superior to Excel's Help, which you seem
to have taken literally, looking at the formula you posted.

http://www.contextures.on.ca/xlFunctions02.html

If still stuck after that, post back.

Gord Dibben Excel MVP

 

[rob p]

Thanks all. I totally missed the "=" sign. Also I plan on looking at Debra's
site.
rob