I'm fairly sure it can. It's been years - almost a decade, now! - since I've had to use Excel for anything productive, but I vividly recall using VLOOKUP to create what were effectively views from a SQL perspective.