P
PaulQ
Can someone please help me find a formula (or two) for this example. If you
can show me a couple of ways to do this (so I can learn), I'd greatly
appreciate it! Thanks!
I'm trying to figure out a formula (or two) that will help me auto-populate
the ? fields within ColumnB of Sheet 2. Also, I want the ? value for the
"8888" row to return blank, since it does not exist in Sheet 1.
Sheet 1:
ColumnA ColumnB
1234 20
4321 10
5678 11
8765 -
9999 12
7777 13
Sheet 2:
ColumnA ColumnB
5678 ?
8765 ?
1234 ?
4321 ?
8888 ?
can show me a couple of ways to do this (so I can learn), I'd greatly
appreciate it! Thanks!
I'm trying to figure out a formula (or two) that will help me auto-populate
the ? fields within ColumnB of Sheet 2. Also, I want the ? value for the
"8888" row to return blank, since it does not exist in Sheet 1.
Sheet 1:
ColumnA ColumnB
1234 20
4321 10
5678 11
8765 -
9999 12
7777 13
Sheet 2:
ColumnA ColumnB
5678 ?
8765 ?
1234 ?
4321 ?
8888 ?