VLOOKUP -to auto-populate columns

Ranjini Walter

Hi

I would like to auto populate the status of the contracts from one sheet to another. How could this be done?

The sheet below contains the status of the contracts .

There is another sheet I want this to be referenced when they enter the contract number:

Could you pls help me with the formula to do this?

Thanks

Ranjini Walter

Rich Stowell

Drop Vlookup - Use INDEX-MATCH or INDEX-COLLECT

Ranjini Walter

Thank you....But can you help me with the formula...I'm getting an error.