Excel: Vlookup Confusion
Jul. 12th, 2008 01:13 am![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
nyykiOkay, 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.
![[identity profile]](https://www.dreamwidth.org/img/silk/identity/openid.png){kind=small}
no subject
Date: 2008-07-12 05:31 pm (UTC)1st parameter is the value you know and want to find in the lookup set.
2nd parameter is the lookup set range. It works best if the lookup set range is in order. The first column in the lookup set should be the one holding the value you're looking for.
3rd parameter is the number of the column in the lookup set which will hold the value you're trying to return. So if the value you know is in the first column, and the value you want is in the third column, you'd enter '3' here.
4th parameter, just enter the word 'false'. Someone explained to me why, I've never remembered it, it's just always false.