View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Silena K-K Silena K-K is offline
external usenet poster
 
Posts: 37
Default VLOOKUP in two worksheets

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