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",???)
|