MrExcel Publishing
Your One Stop for Excel Tips & Solutions

LOOKUP FORMULAS RATHER THAN IF/ARRAYS


Posted by MARTHA on October 06, 2001 9:06 AM

Does anyone know where I can get a book or anytype of
material that would give me more information about using lookups rather than using if / array statements.

Thanx,

Martha


Posted by Aladin Akyurek on October 06, 2001 12:19 PM

Martha

Archive2 at MrExcel has a few examples of using VLOOKUP instead of IF.

To search MrExcel a little easier, go to www.AllTheWeb.com and change the language option to English. Type in Mrexcel followed by the subject of what your looking for, i.e.:

mrexcel vlookup

That should return pages from mrexcel's message board (archive or not), or if it only returns one, there should be the option for "more pages like this" which will return info from the message board specifically...

PS. Above discovery is due to Cory.

Aladin