Good morning all.
I'm trying to write a formula that will:
1) Check to see if a value in column A of worksheet A appears in column A on worksheet B.
2) If it DOES, then display the value from the same row from column B on worksheet B, in column B on worksheet A.
3) If it DOESN'T, display the value "EACH" in column B on worksheet A.
e.g.
WORKSHEET A
__A___ ___B___
111111 EACH
222222 KG
333333 EACH
WORKSHEET B
__A___ ___B___
111123 KG
999999 G
222222 KG
Any suggestions?
Thanks in advance,
C![]()
Bookmarks