| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I list info from one worksheet to another.....
Here is my problem, I have one sheet that has info that is being listed on
another seperate sheet. I can get the info to populate the cell, but it will put the last set of numbers in a cell if the listing is not there. Here is the formula I am using: =LOOKUP(A2,'Lot Check'!$B$2:$B$167,'Lot Check'!$A$2:$A$167) I have tried vlookup and they do not seem to work. Any help would be great. Thanks P.T. in Phx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Worksheet form design | Excel Discussion (Misc queries) | |||
| Sorting a worksheet with drop list | Excel Discussion (Misc queries) | |||
| Can one print a list of worksheet tab labels contained in a workb. | Excel Discussion (Misc queries) | |||
| List box not being displayed in second worksheet | Excel Discussion (Misc queries) | |||
| Lists: Clicking on one item in one list and getting certain info i | Excel Worksheet Functions | |||
Threaded Mode
