How journalists can use VLOOKUP | News & Analysis | Data Driven journalism - 1 views
-
Simon Knight on 10 Jun 17Let's say you have a spreadsheet of thousands of source names with their phone number, email address, home address, and comments/notes. Depending on how large your list is, manually sorting through that list could get tedious and inefficient. Alternatively, you could set up VLOOKUP formulas to have your source's information pop up by simply typing in the source's name as your lookup value[M1] .