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.
Homework? At least make an attempt to solve the problem, and if you can't get it post your results and we'll help.
Markbnj
Programming mod
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.
Homework? At least make an attempt to solve the problem, and if you can't get it post your results and we'll help.
Markbnj
Programming mod
Last edited by a moderator: