match up columns and move data
On Sep 11, 2:25*pm, ngg wrote:
Dave,
Here is what worked for me. Thank you for your help.
In D1, I used:
=IF(ISNA(VLOOKUP($A1,$B:$C, 1, 0)), "", VLOOKUP($A1,$B:$C, 1, 0))
In E1, I used:
=IF(ISNA(VLOOKUP($A1,$B:$C, 2, 0)), "", VLOOKUP($A1,$B:$C, 2, 0))
--
ngg
"Dave Peterson" wrote:
Check your other post.
ngg wrote:
I have 2 columns with numbers in them.(they are much bigger than my
examples). All numbers in column B exist in column A but not all numbers in
column A exist in column B. What I need to do is match up B with A. So I need
to find the number 2 in column A and then move the 2 down in column B so it
aligns with the 2 in column A. Is there a quick and easy way to do this? I
have listed my desired result below.
A * * * * * * * * B
1 * * * * * * * * 2
2 * * * * * * * * 4
3 * * * * * * * * 5
4 * * * * * * * * 8
5
6
7
8
Desired result
A * * * * * * * * B
1
2 * * * * * * * * *2
3
4 * * * * * * * * *4
5 * * * * * * * * *5
6
7
8 * * * * * * * * *8
ngg
--
ngg
--
Dave Peterson
Much better than my solution. Thank you Dave, and thank you ngg for
posting your solution.
S
|