Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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'. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Vlookup problem | Excel Worksheet Functions | |||
VLOOKUP Problem | Excel Worksheet Functions | |||
vlookup problem | Excel Discussion (Misc queries) | |||
VLOOKUP problem | Excel Worksheet Functions | |||
VLOOKUP problem | Excel Discussion (Misc queries) |