VLOOKUP &/or MATCH Function Help

I'm a noob on the forum and my basic Excel modeling skills have diminished due to my lack of use over the last couple of years. Historically, I used to use the hlookup nested in a vlookup function, but I have been seeing examples of INDEX and MATCH FUNCTIONS. If I want to create a basic formula that will return the value for 2 inputs, such as a ref # ID (around 50 unqiue IDs) in column A and then 11 different constituents in column B for each unique ref ID that have results (values) for each constituent in Column C. Say I want to pull a value (result) for a specific ID, say CC 1281444-002, and for constituent Total Nitrogen. How would I go about doing so? I've tried, unsuccessfully to use a combination of INDEX and MATCH, and VLOOKUP and MATCH.

I've searched the forums and can't seem to find the solution that works, because I keep returning NA values. I attached a sample set of the raw data which is only a portion of the raw data that populates a large spreadsheet with many more rows and columns.

Thanks in advance.