If value in columns on separate sheets match input vale from column next to it

Try (untested)

in Sheet2!B1
=IFERROR(VLOOKUP(Sheet2!A1,Sheet1!$BE$1:$BE$1000,1,0),"")
and copy down column B

Originally Posted by jonwool

I need a formula that will do the following:
If the value in Sheet1 Column BE matches a value in Sheet2 Column A then display the value of the cell next to it in Sheet2 Column B
Hope that makes sense

It is not very clear (for me, at least)
If you need to compare BE and A , row by row,
=IF('sheet1'!BE1='sheet2'!A1,'sheet2'!B1)
If you need to lookup cell BE1 in column A and returns value in column B:
=VLOOKUP('sheet1'!BE1,'SHEET2'!A:B,2,0)