Matching data between two sheets

**elad** · 01-11-2008, 10:44 AM

Hi

I have som problem matching data between two sheets.

Sheet A is where the data should be filled out based on raw data in sheet B. The only match I have is the JobID number. So If JobID in Sheet A and Sheet B match, copy the values in selected columns from sheet B to A

In some cases it is possible that the raw data (sheet B) has more JobID`s than in sheet B, and if that is true, I would like to add it as a new job in Sheet A (after last row). I have made an example in uploaded sheet that explains it more in details.

Thanks for any help!

Elad

**oldchippy** · 01-11-2008, 11:06 AM

You need Vlookup, here is a link to explain more

http://www.contextures.com/xlFunctions02.html

See also attached

**elad** · 01-11-2008, 12:48 PM

Thanks a lot, I shall try that. But what about that problem IF not the JobID does not exist? Any solution to that?

**oldchippy** · 01-12-2008, 07:09 AM

I've adjusted the formula where no match is found

**elad** · 01-12-2008, 12:17 PM

Hi and thanks again.

Its almost right, but the JobID is "unknown" for sheet A. Sheet B is always the sheet where the Job is placed first. So it never happens that a jobID in Sheet A not is in Sheet B.

So if the jobID in Sheet B does not find the matching JobID in Sheet A, it shal copy it in to Sheet A (selected collumns, JobID, Customer, Employee...etc. ) as a new row (after the last used row)

Elad

**oldchippy** · 01-12-2008, 04:04 PM

Hi Elad,

The easiest way to see whether the ID is on SheetB, but not on SheetA, is to put this in M8 in your example

=IF(ISERROR(VLOOKUP(G8,$A$8:$A$12,1,FALSE)),"Not on SheetA","")

This will flag up any ID's that are missing in SheetA, then you can go to SheetA and put the ID's in.

**elad** · 01-13-2008, 08:17 AM

Hi

I think i will go for that solution. The only thing I have to do manually is to enter the JobID in sheet A, and then the rest will be autofilled.

Thanks again for great help.

Elad