Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- A | B | C | D
- Car 1 | 03-01-2017 | Car 1 03-01-2017 | 1
- Car 2 | 03-01-2017 | Car 2 03-01-2017 | 1
- Car 3 | 04-01-2017 | Car 3 04-01-2017 | 1
- Car 4 | 05-01-2017 | Car 4 05-01-2017 | 1
- Car 2 | 06-01-2017 | Car 2 06-01-2017 | 1
- =IFERROR(VLOOKUP(A2&" "&B1,C6:D10,2,FALSE), 0)
Add Comment
Please, Sign In to add comment