Assuming sheet name is "Easy Dial" then VLOOKUP should look like;
=VLOOKUP(A76,EasyDial!A:B,2,FALSE)


For referencing another workbook use;
=VLOOKUP(A76,'[Copy of index.xls]Sheet1'!$A:$B,2,FALSE)

Best way is to type =VLOOKUP(A1, then click on the sheet and then range you
want...


"Marco Lorenzo" wrote:

I have done this before but can't remember how.

How do I reference a sheet tab name in my vlookup?