Vlookup not working

[tradecop]

in the first sheet I have a colour in column B on one sheet, I also have in another sheet column A a number and coloum B the colour again,
I need to do a formula to look on the first sheet in column B, then look on the second sheet for the same colour in column B and if there was a match bring the number value in column A back.

Work in a company and just trying to make work quicker by using vlookup. Not sure on the formula to use.

Ok, so since you're saying this isn't homework, I will leave your repost of the previously closed thread open, however you'll get more and better assistance if you give a better description of your problem.

Markbnj
Programming mod

 

[Tweak155]

So on one sheet you only have colors but nothing in column A? Not sure why you'd use colors... just use numbers in column B. Then write the matches to another column like C.

The best way to go by colors is through a macro.

 

[tradecop]

Yes in column A we have a internal reference,
The colour is in column B as words but I need it to show a number, so I have another workbook with the colours and the corosponding number, I know this can be done by a vlookup which be the easiest way as another employee used to use it I just don't know the formula.

 

[Hmongkeysauce]

If I understand you correctly, you have:

Sheet 1: Column B has color names in it
Sheet 2: Column A has number and Column B has color names in it

And you want to bring the number from Sheet 2 to Sheet 1 using VLOOKUP. If those assumptions are correct, then, VLOOKUP will only work if on Sheet 2 the first column is the color and the second column is the number. VLOOKUP requires the matching column in the table_array to be the first column.

 

[tradecop]

great all sorted...