Looking for an Excel Wiz

[srothman]

Looking for someone that can help me extract some data in Excel.

Attached is a sample sheet with some dummy data. (Renamed from .xlsx to .txt)

I need to have sheet one find a value in sheet 2 (Unit) and then populate the relevant field (Environment) from sheet two to the list in sheet one.

Re-sorting the sheets is not an option, it will need to be a lookup of sorts.

It's probably really easy, I'm just a muppet.

View attachment sample_data.txt

 

[Cray]

Vlookup

=VLOOKUP(A2,Sheet2!A:C,3,0)

This is for Cell B2, but you can drag the formula down for successive cells...

 

[Nemus]

=VLOOKUP(A2;Sheet2!A1:C6;3)
Replace ";" with ",", if necessary.

 

[srothman]

See, I knew the smart people could do it in like 2 seconds Thanks.

 

[maumau]

Agree, there are smart people here and they don't mind sharing their knowledge. Kudos to them.