try this

=INDEX(Sheet2!B1:B10,MATCH(TRUE,EXACT(A1,LEFT(Shee t2!A1:A10,4)),0))

this is an array function, use Ctrl + shift + enter



On Nov 15, 10:01*am, GAIDEN wrote:
SHEET 1 * * * * SHEET 2

A * * * * * * * A * * * * * * * B

2011 * *| * * * 204200000 * * * * * * * * * * * LOGO
2015 * *| * * * 201500000 * * * * * * * * * * * AGEN
2022 * *| * * * 201100000 * * * * * * * * * * * STAR
2032 * *| * * * 205400000 * * * * * * * * * * * DURA
2034 * *| * * * 203200000 * * * * * * * * * * * WRAP
2035 * *| * * * 203500000 * * * * * * * * * * * WORK
2042 * *| * * * 202200000 * * * * * * * * * * * GROU
2054 * *| * * * 203400000 * * * * * * * * * * * ALTI

I'm trying to display the values in column B (Sheet 2) next to the values in
column A (Sheet 1) by using the 1st 4 digits in column A (Sheet 2).