I have used the 'Define Name' to name tables and also named the worksheets as
such:
worksheet1 name = SubroLog
worksheet 1 has a table with defined table named 'subrolog'

A B
Headers ClaimNo MemberNo
104068 =VLOOKUP(SubroLog![ClaimNo],CTCNK02![NKCLMN],3,FALSE)

worksheet2 name = CTCNK02
worksheet 2 has a table with defined table named 'CTCNK02'

A B C
Headers NKCLMN NKICNO NKCUST
469 3490 102899
23409 860 32340
104068 4821 603781

I want the function to use the claim number I type into the first
worksheet(SubroLog) to lookup the matching claim number on the second
worksheet2(CTCNK02) and populate the customer number from worksheet2(CTCNK02)
column 3

end result for my 'SubroLog' would like like the following:
A B
Headers ClaimNo MemberNo
104068 603781

Am I even using the correct lookup? (vlookup or hlookup)



"NPell" wrote:

On Apr 8, 4:29 pm, 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'.

Im going home soon, so i used it as standard.. Assuming its this..

A B C
1 NKCLMN NKICNO NKCUST
2 104053 90789 547811
3 4439 87689 208176
4 104068 40129 630085

A B
1 CLAIM NO MEMBER NO
2 104053 *****


To stop the formula splitting lines, its where stars are and its;

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