I have two worksheets.
First worksheet has the contract numbers. One column with 100 rows.
Use the contract numbers from first worksheet and look for a match in second worksheet. Second worksheet has five columns and about 800 records. I can use vlookup to find the matching contract numbers from first to second worksheet.
Once I find the match, then I need to pull the value from the 3rd column of the second worksheet with the matching contract number.
How do you do that?
Last edited by ButteredToast; 12-05-2018 at 10:09 PM. Reason: solved
OK, next time provide what I had to build. An example of what is needed in Excel format.
the key would be the contract number
=vlookup(key,range,field,exactflag)
the range would be the a thru z columns in the second sheet that I have named "Full info"
the field is 3 because you requested the third field
0 means find an exact match
I added the basic error handling function to flag out those contracts (if any) that are not in the Full Info tab.=iferror(vlookup(key,range,field,exactflag),"No Match")
Problem solved, thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks