VLOOKUP or Other Function?

[Bob]

This is a continuation of my question from last Friday.

I have one table with the following data:

Project Type Activity Code Cap/Exp
11111 CMG Exp.
41500 CMG Cap.
40090 PJM Exp.
Etc.....

I also have one spreadsheet that has the first 2 columns
listed here already populated so basically I just need to
populate the Cap/Exp column. Is there a function available
that would be able to use the original table to populate
the Cap/Exp column in my other spreadsheet?

Thanks.

Bob

 

[Frank Kabel]

Hi Bob
use the following array formula (assumptions: the lookup sheet is
called 'projects' and the lookup values are on your other sheets in A1
and B1)
=INDEX('projects'!$C$1:$C$100,MATCH(A1&B1,'projects'!$A$1:$A$100&'proje
cts'!$B$1:$B$100,0))

Enter this formula with CTRL+SHIFT+ENTER (array formula)

 

[Bob Phillips]

=VLOOKUP(A2,Sheet2!A2:C10,3,False)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Bob]

I tried the INDEX function however I received an #N/A
error. Not sure if I've typing it in correctly or not.

My table columns are J2:L4 and the data in the spreadsheet
are in columns M&P and I typed the function in column Q.

Here is what I typed:
=INDEX(Projects!$L$2:$L$4,MATCH(J2&K2,Projects!
$J$2:$J$4&Projects!$K$2:$K$4,0))

Thanks.

Bob