The table ranges are incorrect in your formula - I think you mean
this:

=VLOOKUP(O3,Sheet2!A3:B6,2,FALSE)

Hope this helps.

Pete

On Jan 16, 3:37*pm, Sean W. wrote:
I am recieving an error when I use the VLOOKUP Function. *Below is the actual
formula I am using.

=VLOOKUP(O3,Sheet2!A3:B6:$B$8,2,TRUE)

With O3 Cell "ID65"

and the reference table on sheet2 being:
ID61 * *3
ID65 * *2
ID67 * *4
ID68 * *1

The error states a VALUE# error. *Anyone know how to fix this problem?



"Bernard Liengme" wrote:
Have a look in Help at VLOOKUP
Then come back if more questions
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Sean W." <Sean wrote in message
...
I need to add a new column based on an existing column of data.

The existing data is in the format below:

ID67
ID6802
ID6802
ID61
IA91
IA92
BMID75
BMID25

Each one of the data points will be grouped into different categories like
below,

ID67 * = *Red
ID6802 *= Orange
ID6802 *= Orange
ID61 *= Pink
IA91 *= Brown
IA92 *= Brown
BMID75 = Black
BMID25 = Black

I would manually do it but there are a couple thousand rows. *Also there
are
about 400 different types of data ("IA91") that have an associated group
("Brown").

Can someone give me a formula for this that can be applied to multiple
spreadshirts once the association is established?- Hide quoted text -

- Show quoted text -