Excel "Look Up" formula...need help.

[logisticsman]

Could someone help me debug this "look up" formula. It's no longer working. I have to double click on every cell and press enter for it to work. Would a "VLOOK UP" work better. If so, how? Please help.

=LOOKUP(Carriers!F55,Carriers!$A$2:$A$54,Carriers!$B$2:$B$54)

Thanks!
Logisticsman

 

[GlennUK]

When you say:

I have to double click on every cell and press enter for it to work.

it simply sounds like you have calculation switched to manual. Do menu command Tools/Options/Calculation and make sure the Calculation mode is Automatic.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[logisticsman]

That solved the problem. Thanks!

Another question. I want to keep the auto fill by double clicking on the edge of a cell. But I don't want the numbers to climb up or change. I just want the same number to fill the rest of the cells.

Thanks!!!

 

[KenWright]

If you measn you want the exact same formula in every cell for whatever reason, (and this would be pointless), then simply lock down the reference, eg instead of

=LOOKUP(Carriers!F55,Carriers!$A$2:$A$54,Carriers!$B$2:$B$54)

Try

=LOOKUP(Carriers!$F$55,Carriers!$A$2:$A$54,Carriers!$B$2:$B$54)

Note the dollar signs round the F55 which lock that reference.

Now, the reason I say it is pointless is because they will all give you the exact same result plus the overhead of all those calcs from the function calls. What you may as well have done is for example assuming your formula was in A2, then in A3 simply put =A2 and in A4 put =A3, then select and double click to autofill, which will give you the exact same results, but will be far less overhead on your worksheet.

Regards
Ken............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------