key stoke to "value out" a vlookup formula
 

I remember there being a key stroke to "value out" the look up field in a
vlookup formula, but I can't remember the combo. I'll try to explain better.

=vlookup(A1,Sheet1A1:F125 <--- when choosing (highlighting) this section
you can hit the key stroke(s) in question and it will automatically put the
$'s in the formula to hold the correct values in place.

sorry if my termanology is off.. I hope you get the gist of what I'm asking
for here.

Thanks in advance.

key stoke to "value out" a vlookup formula
 

Roger

Try "F4"

Mike Rogers

"Roger" wrote:

I remember there being a key stroke to "value out" the look up field in a
vlookup formula, but I can't remember the combo. I'll try to explain better.

=vlookup(A1,Sheet1A1:F125 <--- when choosing (highlighting) this section
you can hit the key stroke(s) in question and it will automatically put the
$'s in the formula to hold the correct values in place.

sorry if my termanology is off.. I hope you get the gist of what I'm asking
for here.

Thanks in advance.

key stoke to "value out" a vlookup formula
 

F9

--
Regards,
Luc.

"Festina Lente"


"Mike Rogers" wrote:

Roger

Try "F4"

Mike Rogers

"Roger" wrote:

I remember there being a key stroke to "value out" the look up field in a
vlookup formula, but I can't remember the combo. I'll try to explain better.

=vlookup(A1,Sheet1A1:F125 <--- when choosing (highlighting) this section
you can hit the key stroke(s) in question and it will automatically put the
$'s in the formula to hold the correct values in place.

sorry if my termanology is off.. I hope you get the gist of what I'm asking
for here.

Thanks in advance.