VLOOKUP Question

[Bob]

I have a question regarding VLOOKUP and whether it can be
used for a three column table. For example, I have the
following data:

Project Code Cap/Exp.
11111 COD Exp
41000 COD Cap

Is there any type of function that will differentiate
between the 2 different types of projects and autopopulate
the cells accordingly?

Thanks.

 

[Frank Kabel]

Hi Bob
something like
=VLOOKUP(11111,A1:C3,2,0)
and
=VLOOKUP(11111,A1:C3,3,0)

 

[Bob]

What would I do though when the first number changes from
11111 to 40000, 40005...etc?

Thanks.

 

[Frank Kabel]

Hi
replace this number with a cell reference. So something like
=VLOOKUP(X1,A1:C3,2,0)
where X1 stores your project number to search for

 

[Bob]

Thanks

If I have more than 1 project number wouldn't I be able to
store only 1 number in the X1 cell reference?

 

[Frank Kabel]

Hi Bob
now i'm a little bit lost
not sure what you're trying to achieve?

-
Regards
Frank Kabel
Frankfurt, Germany