Matching Two Columns with a twist

redmanx03

New Member
Joined
Jun 23, 2010
Messages
17
I have 3 columns two cloumns are ACCT numbers and third is comments
Column A has a longer list of acct numbers than does B, But column B had the same amount of rows as does C,(I copied and pasted from another sheet) How can i match A to B while still keeping C intact to B?

Column A Column B Column C
123 456 ihjh
345 123 jkjh
745 346 wqpeou
897
346
 

Fowmy

Well-known Member
Joined
Jul 10, 2008
Messages
506
Move the Column A to a new sheet use vlookup to match waht is in Column B
 

Fowmy

Well-known Member
Joined
Jul 10, 2008
Messages
506
What did you mean by "match A to B while still keeping C"
 

redmanx03

New Member
Joined
Jun 23, 2010
Messages
17
i used this code and it worked

=IF(ISNUMBER(MATCH(A2,$B$2:$B$400,0)),INDEX($C$2:$C$400,MATCH(A2,$B$2:$B$400,0)),"Not Found")
 

hardeep.kanwar

Well-known Member
Joined
Aug 13, 2008
Messages
687
i used this code and it worked

=IF(ISNUMBER(MATCH(A2,$B$2:$B$400,0)),INDEX($C$2:$C$400,MATCH(A2,$B$2:$B$400,0)),"Not Found")

Try this

Excel Workbook
ABCD
1ABCE
2123456ihjhjkjh
3345123jkjhNot Found
4745346wqpeouNot Found
5897Not Found
6346wqpeou
Sheet3
Excel 2007
Cell Formulas
RangeFormula
D2=IFERROR(VLOOKUP(A2,$B$2:$C$6,2,0),"Not Found")
D3=IFERROR(VLOOKUP(A3,$B$2:$C$6,2,0),"Not Found")
D4=IFERROR(VLOOKUP(A4,$B$2:$C$6,2,0),"Not Found")
D5=IFERROR(VLOOKUP(A5,$B$2:$C$6,2,0),"Not Found")
D6=IFERROR(VLOOKUP(A6,$B$2:$C$6,2,0),"Not Found")




Produce Same Result as you want
 

Forum statistics

Threads
1,085,563
Messages
5,384,443
Members
401,901
Latest member
Cherry20

Some videos you may like

This Week's Hot Topics

Top