lookup question

[sabot7726]

Hi, I'm trying to make a roster spreadsheet. My goal is to be able to enter a badge number into one column and have 3 other columns of data fill in automatically once I hit enter.

So far I've tried using vlookup but I noticed the data does not update if I change the value in the lookup_value. It only works the first time. If I change the entry the sheet is using for lookup_value, I have to click into the vlookup cell and hit enter again to get it to change.

This spreadsheet would be adjusted on a near constant basis, is there any way for the sheet to automatically re-check the table_array to match a new lookup_value if I edit/change it?

Or on the other hand, is there another way to do this that is easier?

 

[VoG]

Make sure calculation is set to Automatic (Tools > Options > Calculation).

 

[Travis]

welcome to the board.

I would use vlookup for that and it should update when there are changes.

Does it update when you press F9? If so then check your calculation options and change from manual to auto.

Is the data its looking at in another worksheet? I think it would see still see that change, but maybe not.

 

[sabot7726]

Wow, I never woulda thought that'd be turned off by default. Looks like that was it, thanks.