![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
Excel: Vlookup Confusion
Jul. 12th, 2008 01:13 amOkay, I've looked at four different sites, including the Microsoft info on this function, and for some reason it just doesn't wan't to make sense to me.
Anyone use this function and know how to explain how it works to me? I just realized that I somehow blanked a rather important row in a 1600+ row spreadsheet, and I have another copy of the sheet I emailed to someone, but it's been modified enough that only a lookup function is going to make this a sane thing I can create something that'll do the trick if I can find a good way to actually make this function work. I know it does, I've seen it work for other people.
Anyone use this function and know how to explain how it works to me? I just realized that I somehow blanked a rather important row in a 1600+ row spreadsheet, and I have another copy of the sheet I emailed to someone, but it's been modified enough that only a lookup function is going to make this a sane thing I can create something that'll do the trick if I can find a good way to actually make this function work. I know it does, I've seen it work for other people.
