I'm trying to copy another cell when some matching any cell value by using vlookup but it simply not work as well please check my below format.

Result: #N/A


My Sheet which I want to use this formula

enter image description here And Below is the sheet I that I try to copy the date value (column 5th)

enter image description here

  • your screenshot doesn't contain column headers, but it seems that you try to look for data in the second column. VLOOKUP can look for values in the first column of the range only. You may use INDEX and MATCH instead. May 5, 2017 at 9:54
  • Should you give me some idea for using index and mathc May 5, 2017 at 10:02

1 Answer 1


I think what you want is the DATE column 6 matched with column 2 Which is 4 difference starting at column C


The FIRST column is C which is what it will match against

The Last parameter (0) means EXACT Match

  • Index and match would be =INDEX(OROBmc!F13:F50, Match(D77,OROBmc!C13:C50,0))
    – Ross
    May 5, 2017 at 10:09

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .