Pulling in values from another sheet
I have a column with a Contract Number and to the right I want to auto-fill two associated columns, Vendor and Contract Manager linked to this same contract number from another sheet.
I have tried all manner of VLOOK-UP and INDEX/MATCH combinations which I know from Excel but no success. Is there a basic formula to build on for this please?
The source sheet for the Vendor entries has two indent levels. Don't know if that matters.
Help Article Resources
Check out the Formula Handbook template!