BASICS - Microsoft Project, Excel, Access, Power BI Live ...

Click in cell E4 and type. =VLOOKUP(D4,A4:C11,2,FALSE) This will use a value entered in D4 (in this case 1004), look for it in the range A4:C11, and specifically look in the 2nd column of that range for the matching content, and pull up the result (Yellow). ................
................