matching key fields between two workbooks and displaying info when

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I have two workbooks with the following info that should be the same - but I
know it isnt
Work book 1
Column A ColumnB
Op number EA100, Part number BAC100123
Op number EA100, Part number BAC100124
Op number EA100, Part number BAC100125

Workbook 2
Op number EA100, Part number BAC100123
As above
As above

I want to create a formula that compares the op number and then flags when
the part number is not the same.
 
Use the vlookup function.
In Col C put a 'cheater formula' something like...
=IF(VLOOKUP(A1,[Book3]Sheet2!$A:$B,2,FALSE)<>B1,"Not the same!","")
--
HTH,
Gary Brown
(e-mail address removed)
If this post was helpful to you, please select ''YES'' at the bottom of the
post.
 
Thanks for your help - I tried the formula and it matches the first part
number in column b1 for EA100 but then says B2 isnt a match when it is? Can
you help further

Gary Brown said:
Use the vlookup function.
In Col C put a 'cheater formula' something like...
=IF(VLOOKUP(A1,[Book3]Sheet2!$A:$B,2,FALSE)<>B1,"Not the same!","")
--
HTH,
Gary Brown
(e-mail address removed)
If this post was helpful to you, please select ''YES'' at the bottom of the
post.



tukky142 said:
Hi

I have two workbooks with the following info that should be the same - but I
know it isnt
Work book 1
Column A ColumnB
Op number EA100, Part number BAC100123
Op number EA100, Part number BAC100124
Op number EA100, Part number BAC100125

Workbook 2
Op number EA100, Part number BAC100123
As above
As above

I want to create a formula that compares the op number and then flags when
the part number is not the same.
Click to expand...
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding matching cells between two workborks and updating cell con 2
How do I match 3 different workbooks information for similar data? 2
matching & combining data from seperate worksheets 2
Excel Drag autofill only part of formula 3
comparing two sheet of data -- cost price increases 2
Need a Match formula 3
how can I compare two columns 1
join data in multiple cells when adjoining cells match criteria ?? 1

Back
Top