Limits to VLOOKUP capability

[bhinhb]

I have never used this type of formula and simply trying to get more than one cell (2-3) to fill in when I input one cell.
ex. Type in a part # from column A, the correlating info from B and C are filled in. I have only seen the example of one cell (ex. part / price).

Can this be accomplished in Excel?

[Cutter]

If you are asking how to get the column C value, then:

=VLOOKUP(part#,range,##,FALSE)
The range must be at least 3 columns wide. The first column will contain the part #'s. The ## in the formula is the number of the column from which you want to retrieve the data. So, if you want the data from the column adjacent to the part #'s you would use 2. To get a value from another column you change the ## to reflect that. If it's 2 columns to the right of the part #'s you would use 3 (remember that the part #'s column counts as 1).

Here's a link: http://office.microsoft.com/en-us/ex...in=HP010079186

[bhinhb]

Yes. Thank you that makes sense the problem I'm having is that I need 2 columns of info not just one to be associated to the part #.

So Type in A and need B and C to come up. (A) Part # with (B)Die # and (C)Weight.

[Cutter]

Yes, I get that. You put a VLOOKUP() in B and another VLOOKUP() in C. The only difference in the 2 will be the column # from which to retrieve the data.

If you have trouble with it tell us specifics about the ranges you are using and we can give you the formulas to use.