Excel - HELP

[TXHUNT3R]

Driving myself nuts here.

Trying to help my boss out, we just upgraded our system and lost alot of our settings.

This is for the Excel guys / gals.

When I do a vlookup, my array automatically locks down when I select the range I am bumping against.

My bosses computer did not carry over the setting and he is having to manually lock the array each vlookup.

What setting will automatically lock the array when you select the range?

Thanks!

[Reaper33]

I know the shortcut is F4. Let me see if I can find the setting. I have never run with the setting on before.

[TXHUNT3R]

I know you can lock it down with F4 but i'm sure there is a simple setting I am missing because mine auto locks down.

[Reaper33]

Ya I couldn't find a setting. The only thing that I could think of is that the Array that you are looking up to is already set to "absolute". Like the whole sheet was formatted to absolute or something. I have never known it to auto lock like that so it got me curious. If it is a setting I have no clue where its at.

[TXHUNT3R]

Ya I couldn't find a setting. The only thing that I could think of is that the Array that you are looking up to is already set to "absolute". Like the whole sheet was formatted to absolute or something. I have never known it to auto lock like that so it got me curious. If it is a setting I have no clue where its at.

Good point, might be the sheet, because the data he is bumping is different from my copy.

I don't trust anyone with my files

[Jason]

Can you use the $signs in the formula to lock it down?

[Reaper33]

I asked a few other guys that I would consider to be in the "advanced" level of excel like me and they didn't know either. Also the google is coming up empty. You got me on this one brother.

[TXHUNT3R]

I asked a few other guys that I would consider to be in the "advanced" level of excel like me and they didn't know either. Also the google is coming up empty. You got me on this one brother.

Yeah, same here on being "advanced", first I hated excel and now over 7 years later, I LOVE it... amazing tool

Thank you for your time, brother!

[TXHUNT3R]

Can you use the $signs in the formula to lock it down?

Yes, just was trying to find the setting to keep it locked down automatically, we run alot of reports so its just a convenience thing

[duckmanep]

So your computer auto locks on all worksheets? You can open up a new blank one, create a vlookup and it will auto lock?

[Buckshot-73]

Cntrl+ alt+delete+ f9.



At the same time.

[TXHUNT3R]

So your computer auto locks on all worksheets? You can open up a new blank one, create a vlookup and it will auto lock?

Yes, once I go to select my range (ctrl + shift - arrow over - arrow down) my $ signs auto populate into the formula. I don't have to add them or hit F4.

[tmurray]

You can give the Array a name in the name manager if you like. Highlight the lookup data then go to Formulas>Name Manager and give it a name... let's just call it Jared.

=vlookup(G2,Jared,2,false)

[Reaper33]

Yeah, same here on being "advanced", first I hated excel and now over 7 years later, I LOVE it... amazing tool

Thank you for your time, brother!

Yes its a great program. I couldn't live with out it. Then I stacked learning to code on top of it and now I can walk a line that most ppl cant between the IT world and the business world

[snappertapper]

Ya I couldn't find a setting. The only thing that I could think of is that the Array that you are looking up to is already set to "absolute". Like the whole sheet was formatted to absolute or something. I have never known it to auto lock like that so it got me curious. If it is a setting I have no clue where its at.

this....