I have "messed with" VLOOKUP several times and can sometimes get it to work
for me. Other times, my data winds up scrambled or other errors occur. I
have read the Excel VLOOKUP help (several times); but I'm looking for a link
to a site that would take me through the process step by step, with advice on
common mistakes. Can one or two of you possibly post your favorite VLOOKUP
How-To sites?

Thanks

Lookup VLOOKUP() in Excel Help Menu

"ConfusedNHouston" wrote:

I have "messed with" VLOOKUP several times and can sometimes get it to work
for me. Other times, my data winds up scrambled or other errors occur. I
have read the Excel VLOOKUP help (several times); but I'm looking for a link
to a site that would take me through the process step by step, with advice on
common mistakes. Can one or two of you possibly post your favorite VLOOKUP
How-To sites?

Thanks

I've use the help menu but I'm looking for something more detailed than the
help menu. Something that provides multiple examples. Something that will
warn against mistakes; like failing to use absolute cell references in the
VLOOKUP reference table. Looking for details...

"Teethless mama" wrote:

Lookup VLOOKUP() in Excel Help Menu

"ConfusedNHouston" wrote:

I have "messed with" VLOOKUP several times and can sometimes get it to work
for me. Other times, my data winds up scrambled or other errors occur. I
have read the Excel VLOOKUP help (several times); but I'm looking for a link
to a site that would take me through the process step by step, with advice on
common mistakes. Can one or two of you possibly post your favorite VLOOKUP
How-To sites?

Thanks

This would be my favourite site.

http://www.contextures.on.ca/xlFunctions02.html

Site built and maintained by Debra Dalgleish........Excel MVP


Gord Dibben MS Excel MVP

On Thu, 5 Jun 2008 07:16:01 -0700, ConfusedNHouston
wrote:

I've use the help menu but I'm looking for something more detailed than the
help menu. Something that provides multiple examples. Something that will
warn against mistakes; like failing to use absolute cell references in the
VLOOKUP reference table. Looking for details...

"Teethless mama" wrote:

Lookup VLOOKUP() in Excel Help Menu

"ConfusedNHouston" wrote:

I have "messed with" VLOOKUP several times and can sometimes get it to work
for me. Other times, my data winds up scrambled or other errors occur. I
have read the Excel VLOOKUP help (several times); but I'm looking for a link
to a site that would take me through the process step by step, with advice on
common mistakes. Can one or two of you possibly post your favorite VLOOKUP
How-To sites?

Thanks