You are reading a single comment by @Dan_W and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
@Dan_W
Needs the 0 in the MATCH ;)
=VLOOKUP(A1, B:C, 2, FALSE)
=INDEX(C:C, MATCH(A1, B:B, 0))