Looking for an Excel Wiz

srothman

Expert Member
Joined
Mar 30, 2010
Messages
2,752
#1
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

Honorary Master
Joined
Oct 11, 2010
Messages
16,130
#2
Vlookup

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

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

Nemus

Senior Member
Joined
Oct 12, 2012
Messages
681
#3
=VLOOKUP(A2;Sheet2!A1:C6;3)
Replace ";" with ",", if necessary.
 
Last edited:

maumau

Honorary Master
Joined
Aug 13, 2009
Messages
11,083
#5
Agree, there are smart people here and they don't mind sharing their knowledge. Kudos to them.
 
Top