Hello Dear Friends !
Am a new member.
Could anyone help me in this query?
In Sheet1
Column A
Green
Green
Orange
Green
Brown
White
etc
In Sheet 2
Column A ColumnB
1 Green
2 Orange
3 White
4 Brown
I need in Sheet 1 (result in column B)
Column A ColumnB
Green 1
Green 1
Orange 2
Green 1
Brown 4
White 3
thanks in advance!
Am a new member.
Could anyone help me in this query?
In Sheet1
Column A
Green
Green
Orange
Green
Brown
White
etc
In Sheet 2
Column A ColumnB
1 Green
2 Orange
3 White
4 Brown
I need in Sheet 1 (result in column B)
Column A ColumnB
Green 1
Green 1
Orange 2
Green 1
Brown 4
White 3
thanks in advance!