first time using a formula in new MS Office program

[tuktuk]

hey there,

i am attempting to do a vlookup on a MS excel program that is completely new and never used formuls.

as i type in "=vlookup(B2,PO,2,False)" nothging happens, that is it doesn't try to figure out the equation. it acts as if the formula is text within the cell.

any ideas.

T

 

[VoG]

Tools > Options > Calculation tab. make sure automatic calculation is enabled.

 

[tuktuk]

yep that is checked.....any other ideas

 

[tuktuk]

i even gone so far to test with a simplier formula.....

in cell D2 i typed "=C2" and the result in the cell is "=C2"

i am perplexed

 

[tuktuk]

hmmmmmm everyday you learn more.....i formated the cells to "General" and it now calculated the formula. i guess it was reading it as text.

thanks

 

[tuktuk]

ONE QUESTION NOW THOUGH.......strange thing

i am trying to copy the "=vlookup(A2,po,2,fasle) down to the last active row BUT it appears to only returns the value of the active cell that i copy form EVEN THOUGH the formula in a few rows down appears to be correct.

for example, the results for the vlookup in row2 is 18987. then i drag this formula to the last row (R180). all of the cells from row 3 to row 180 return a value of 18987 BUT THE FORMULAS are correct...........that is "=vlookup(A3,po,2,false)" for row3,"=vlookup(A4,po,2,false)" for row4,"=vlookup(A5,po,2,false)" for row5, etc.

any ideas?

 

[marka87uk]

Make sure automatic calculation is checked again! Press F9 to see if it'll update.

 

[tuktuk]

yeah buddy......within test i changed calcs to manual.......after changing it back to AUTO solved my issues.

THANKS tuktuk