- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
re: Excel - I Need a Wizard
Posted on 3/13/19 at 11:03 am to deeprig9
Posted on 3/13/19 at 11:03 am to deeprig9
Shortcut for the $ is F4.
If you used the formula box to enter the VLookup, you would claim the table array, and then hit F4 and it will freeze the lookup table criteria.
If you're typing the formula out in the formula bar, once you claim your table array hit F4 and it will add the $ where they need to go.
(Lookup_value,table array(hit F4 here),Col_index_num, Range_lookup).
If you used the formula box to enter the VLookup, you would claim the table array, and then hit F4 and it will freeze the lookup table criteria.
If you're typing the formula out in the formula bar, once you claim your table array hit F4 and it will add the $ where they need to go.
(Lookup_value,table array(hit F4 here),Col_index_num, Range_lookup).
Popular
Back to top
Follow TigerDroppings for LSU Football News