ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   I want Vlookup Result in one fixed Cell while Entring Data in a Sh (https://www.excelbanter.com/excel-discussion-misc-queries/164495-i-want-vlookup-result-one-fixed-cell-while-entring-data-sh.html)

Nasir

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


All times are GMT +1. The time now is 03:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com