You are reading a single comment by @spenceey 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.
@spenceey
Hopefully this will help out:
a b c
1 cat 4
2 dog 45
3 ham 24
4 egg 67
Let's say I want to look up how many pieces of Ham I've sold.
The formula below is in column B1 with the Value to look up in A1
=Vlookup(value to look up in this case A1, where to look up A4:C4,how many rows across is the data to return? 2 in this case, False (generally you want to return an exact amount)