View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nasir Nasir is offline
external usenet poster
 
Posts: 2
Default I want Vlookup Result in one fixed Cell while Entring Data in a Sh

Hi,
I am entring time cards for payroll, I IDNO in Col B. Whenever I enter and
IDNO in Col "B2" I should show the name from other worksheet in Cell "B1".
And when I enter IDNO in "B3" . I want the Name again in Cell "B1" and so on
.. In other words I want the Vlookup value of activecell in "B1"

I hope somebody will help me solving this problem.
Thank you very much
Nasir