| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Determining the Cell Address of a VLOOKUP Result in VBA | Excel Discussion (Misc queries) | |||
| Inputting variable length data - outputting fixed character result | Excel Discussion (Misc queries) | |||
| vlookup shows result one cell above the expected result | Excel Worksheet Functions | |||
| Vlookup is displaying the formula in its cell not the result?? | Excel Worksheet Functions | |||
| VLOOKUP formula appears in the cell I need to see the result in | Excel Discussion (Misc queries) | |||
Linear Mode
