VLOOKUP Question

  • Thread starter Thread starter Bob
  • Start date Start date
B

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.
 
What would I do though when the first number changes from
11111 to 40000, 40005...etc?

Thanks.
 
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
 
Thanks

If I have more than 1 project number wouldn't I be able to
store only 1 number in the X1 cell reference?
 
Hi Bob
now i'm a little bit lost :-)
not sure what you're trying to achieve?

-
Regards
Frank Kabel
Frankfurt, Germany
 
Back
Top