how to use the vlookup function in excel? Ive made a list with data in one spreadsheet. With this data i have created a False and True list based on an IF function. I have furthermore created a counting system that counts 1,2,3...so on every time there is a TRUE. The problem now is that i want to transfer a line of data every time a number is counted, meaning that the line that is marked as TRUE needs to be transferred to the next page. Through googling i found that VLOOKUP might be useful, but i cant figure out how to use it exactly.. Can you help?
Solved by S. F. in 25 mins