Confussed about using vlookup and tables

[J Spensley]

I have read the vlookp posts and I am still confused. I have
spreadsheet with two worksheets. Worksheet 1 has data about product
and worksheet 2 has a table. i.e.

prod line MACH CONSUM SPARE

AZ90 EXIST EXIST EXIST
LJ4 NONMKT EXIST EXIST

In worksheet one if column A contains "AZ90" and column B contain
CONSUM I want the lookup to look on worksheet two and set the value of
(worksheet 1) column C to "EXIST". Correspondingly if Worksheet
column A contains LJ4 and column B contains MACH I want it to se
column C to "NON MKT". The table acutally has about 60 prod lin
options and Just MACH, CONSUM and SPARE as the column types. I can'
figure out the syntax for selecting a specific cell value from th
sheet 2 based on the value of 2 different cells on sheet 1.

Thanks in advance for any hel

 

[Dave Peterson]

If you know what column you're going to return, you can use =vlookup().

But if the row (based on AZ90) and the column (based on CONSUM) both have to be
searched for, you can use:

=index(rng,match(...),match(...))

And to see a nice explanation of index/match, take a look at Debra Dalgleish's
site:
http://www.contextures.com/xlFunctions03.html

Especially the examples.