i am trying to use vlookup but when I am entering formula it is neither giving lookup value not # N/a rather it is giving formula entered as text =vlookup(B2,$T$2:$U$135,2,false)
i am trying to use vlookup but when I am entering formula it is neither giving lookup value not # N/a rather it is giving formula entered as text =vlookup(B2,$T$2:$U$135,2,false)
Last edited by yogeshsharma1981; 07-09-2013 at 04:11 PM. Reason: Solved
Make sure the cell with the formula is formatted as General first.
THEN Re-Enter the formula.
Thanks It worked!!!![]()
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks