Ok, I will try to make this the least complicated to explain as possible.
Sheet 1
Cell
A1 = ABC
A2 = DEF
A3 = GHI
B1 = Mark
B2 = Mark
B3 = Mark
Sheet 2
A1 = ABC
A2 = DEF
A3 = GHI
B1 = Mark
B2 = Sally
B3 = Joe
So, sheet 2 is the true statement... (I want ABC = Mark, DEF = Sally, GHI = Joe) Is there a formula that will make anything in Sheet 1 Column B equal what Sheet 2 says column A's name should be?
I don't know if that makes any sense... I have been trying to create this report for two days now and don't know what side is up or down anymore!
Any help would be appreciated and I can try to clarify if this doesn't make sense.
Wes
Bookmarks