 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / May 2008Vlookup or match function?
I can't quite get this to work, hoping someone can help: I have two worksheets and if there is a match i want it to return a value: sheet 1 A1 = package # b1 = rework reason (this field is blank and is where i want the data populated) sheet 2 f1 = package number g1 = rework reason If there is a matching package number on sheet 2, then i want the rework reason in column G to be placed in the rework reason in sheet 1 column B. Any help is appreciated > sheet 2 > f1 = package number > g1 = rework reason Assuming that the above is actually a TABLE of data. Entered on Sheet1 B1: =VLOOKUP(A1,Sheet2!F:G,2,0) If no match is found the formula will return #N/A.  SignatureBiff Microsoft Excel MVP >I can't quite get this to work, hoping someone can help: > [quoted text clipped - 13 lines] > > Any help is appreciated thanks, that worked and it was easy to do! > > sheet 2 > > f1 = package number [quoted text clipped - 25 lines] > > > > Any help is appreciated Actually, it didnt work as i wanted - as i look at the data the reasons dont match. There may not be a match for every item and the data isnt chronological. Meaning the package number that is on sheet 1 may be in cell A2 on sheet 1 and it may be in cell F6 on sheet 2. > > sheet 2 > > f1 = package number [quoted text clipped - 25 lines] > > > > Any help is appreciated In that case, it sounds like you want to drag copy the formula down column A. SignatureBiff Microsoft Excel MVP > Actually, it didnt work as i wanted - as i look at the data the reasons > dont [quoted text clipped - 35 lines] >> > >> > Any help is appreciated Typo: > In that case, it sounds like you want to drag copy the formula down column > A. That should be: drag copy down column B. SignatureBiff Microsoft Excel MVP > In that case, it sounds like you want to drag copy the formula down column > A. [quoted text clipped - 38 lines] >>> > >>> > Any help is appreciated thanks for your help! > Typo: > [quoted text clipped - 45 lines] > >>> > > >>> > Any help is appreciated |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.