Is Table_S1019203_CTCNK02 a defined name for the table? The worksheet
name? Something else?

If a defined name (assuming it's defined correctly):

=VLOOKUP(A2,Table_S1019203_CTCNK02, 3, FALSE)


If the worksheet name:

=VLOOKUP(A2,Table_S1019203_CTCNK02!A:C, 3, FALSE)

If something else, post back with more info.

In article ,
Leslie wrote:

I'm not familar enough with the functions in Excel and need some help. I
have two worksheets and I'm trying to use the 'vlookup' on my 1st worksheet
to look up data on a imported table located on sheet two.

First worksheet has a table that looks like this:
CLAIM NO MEMBER NO
104068 =VLOOKUP([Claim No],Table_S1019203_CTCNK02[NKCLMN],3,FALSE)

Second worksheet has a talbe that look like this:
NKCLMN NKICNO NKCUST
104053 90789 547811
4439 87689 208176
104068 40129 630085

I am trying to pull over the field [NKCUST] to [Member No] and I apparently
have my formula wrong because all I get is '#Ref'.