Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi there
I have "product information" in one worksheet and in the second sheet "tracking information" of where the product is in the lab. Based on a unique id in the product information worksheet I want to look up product details such as Name, Date, Storage Time, etc and have it automatically inserted in the Tracking worksheet. An example of my VLOOKUP formula is: =VLOOKUP(A3,'Stability Sample Register'!A5:E23,4,FALSE) but it returns #N/A. What am I doing wrong? Thanks for you help, Silena |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
vlookup looking at many worksheets | Excel Discussion (Misc queries) | |||
Vlookup across worksheets. | Excel Worksheet Functions | |||
VLOOKUP using two worksheets? | Excel Discussion (Misc queries) | |||
Vlookup in different worksheets | Excel Worksheet Functions | |||
Using vlookup on two worksheets | Excel Worksheet Functions |