Google Sheets VLOOKUP function can be used to look for a value in a column and when that value is found, return a value from the same row from a specified column. Now if that description sounds nerdy and difficult, here is another way to understand what this function does.

Visit the Learning Center. Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more. I have a data table in a worksheet that uses the vlookup to match a unique value from a cell and populate various other cells with data retreived. The problem is that the formula is active and any blank lookup value returns the usual #NA throughout the data sheet. I thought I might be able to combine an "IF" cell is not empty then Vlookup. The second sheet has a column that uses vlookup to display the price from the formula. I have another column on that same sheet with old prices. I want to use conditional formatting to highlight prices that are different, but it seems to highlight everything based off of the formula, even if the prices are the same.