Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP Formula | Excel Discussion (Misc queries) | |||
VLOOKUP Formula | Excel Discussion (Misc queries) | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Vlookup formula | Excel Worksheet Functions | |||
How do I use Range Names listed in a VLookup table in a formula? | Excel Worksheet Functions |