You are reading a single comment by @Olly398 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.
@Olly398
you need your data in columns, with the 'index' column on the extreme left. The other fields in the function tell it which column you want it to return data from (counting from the left) and whether an exact match is required. And of course which variable you want to trawl for in the index.
=vlookup(lookup value,table array, col index number,exact match required)