VLOOKUP Is NOT CORRECT

  • Thread starter Thread starter Ronald Cayne
  • Start date Start date
R

Ronald Cayne

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",???)
 
What do you think a single Vlookup formua should return into the cell when
there are duplicates ?

Best wishes Harald
 
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))),"NEW",INDEX(PRODUCT,MATCH(K12,JOBID,0)))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code works on sheet but not from code-to-sheet 2
VLOOKUP Question 3
Copy columns and paste with blank column between 5
Advanced Filter works in recorder but not while running macro 5
Array VLOOKUP lookup_Value does not increment 3
vlookup issue 2
VLookup Formula's 2
Sheet to sheet code Type Mismatch 6

Back
Top