Lookup values in cells columns in another sheet

[tripoptrading]

I would like lookup values or text in cells in columns from another sheet in the same XL document.

[#2]

@tripoptrading 

You may try this:

• Formula in Sheet2 cell E14:

=IFERROR(INDEX(Sheet1!B$14:B$19,MATCH($D14,Sheet1!$A$14:$A$19,0)),"")

• Fill the formula across required Range.
• Adjust cell references in the formula as needed.