Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLOOKUP Is NOT CORRECT
Please help me fill in the ???? Offset Command ??
LIST= Sheet 2 Column 1 BLOCK=Sheet 2 A1:G1000 A1 is on Sheet 1 Formula is placed on Sheet 1 B1 Vlookup can't be used as duplicate entries may exist in BLOCK column 1 =IF(ISERROR(LOOKUP(A1,list)),"new",???) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLOOKUP Is NOT CORRECT
What do you think a single Vlookup formua should return into the cell when
there are duplicates ? Best wishes Harald "Ronald Cayne" skrev i melding ... Please help me fill in the ???? Offset Command ?? LIST= Sheet 2 Column 1 BLOCK=Sheet 2 A1:G1000 A1 is on Sheet 1 Formula is placed on Sheet 1 B1 Vlookup can't be used as duplicate entries may exist in BLOCK column 1 =IF(ISERROR(LOOKUP(A1,list)),"new",???) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLOOKUP Is NOT CORRECT
Sorry I was not very clear in presentingf the problem below. I solved my
problem as follows when I formulated the problem more carefully using the INDEX/MATCH combination PRODUCT=RANGE COLUMN 2 SHEET 2 JOB_ID=RANGE COLUMN 1 SHEET 2 FORMULA =IF(ISERROR(INDEX(PRODUCT,MATCH(K12,JOBID,0))),"NE W",INDEX(PRODUCT,MATCH(K12,JOBID,0))) Ronald Cayne wrote: Please help me fill in the ???? Offset Command ?? LIST= Sheet 2 Column 1 BLOCK=Sheet 2 A1:G1000 A1 is on Sheet 1 Formula is placed on Sheet 1 B1 Vlookup can't be used as duplicate entries may exist in BLOCK column 1 =IF(ISERROR(LOOKUP(A1,list)),"new",???) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is Vlookup the correct way to do this? | Excel Worksheet Functions | |||
Vlookup not returning correct value | Excel Worksheet Functions | |||
VLOOKUP not returning correct value | Excel Worksheet Functions | |||
VLOOKUP seems correct, still getting #N/A | Excel Worksheet Functions | |||
Vlookup not returning correct value | Excel Worksheet Functions |