|re: "This is heavy duty excel."|
Not really. VLOOKUP is a function that is used quite often and pretty easy to understand.
VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
lookup_value: The value you want to look up
table_array: The range of cells where the lookup_value can be found in the first column of the range and the other columns contain the data you want to return
col_index_num: The column number of the table_array from which you want to return a value. Note: This may or may not be the same column number as the spreadsheet column. It is the column number within the table_array. e.g. with a table_array of B1:D100, Column B is col_index_num 1, Column C is 2, etc.
range_lookup: Either TRUE or FALSE (or 1 or 0) depending on whether you want an exact match or an approximate match of the lookup_value.
So, in your case, you would use something like this in A3:
=VLOOKUP(A2, Sheet2!$A$1:$C$100, 2, 0)
I'll leave it to you to figure out what goes in A4.
Note: If the lookup_value is not found in the first column of the table_array, VLOOKUP will return #N/A.
Since you are using a Data Validation drop down, this should not be an issue for you, but if it is, you can check for a #N/A value and present a "message" instead:
=IF(ISNA(VLOOKUP(A2, Sheet2!$A$1:$C$100, 2, 0)), "Value Not Found", VLOOKUP(A2, Sheet2!$A$1:$C$100, 2, 0))
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.