Cross Referencing Sheets

Keith Clayton

New Member
Joined
Nov 29, 2005
Messages
1
I am unable to show my problem graphically here due to network restrictions, however, hopefully I can explain what it is I would like to do but cannot seem to make work:

My first sheet consists of 12 engineers with differing/same Microsoft exam passes listed as name/cert#/title (Chris/70-293/Planning MS Win etc.)

Sheets 2 thru X will reflect competency requirements, listing cert#/title. I would like to create 2 additional columns on these sheets, the first cross referencing the cert# on sheet 1 stating cert held or not (I tried an if statement, but it reported false all the time). Additionally, I would like to list the name of the cert holder in the second column, bearing in mind I may have multiple returns from Sheet 1 for the same cert number which I would need to see.

Can anyone point me in the right direction to resolve this please?

TIA
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
Note: I am already helping Keith with this, using a sample spreadsheet he was kind enough to send me. I see the matter solved in the very near future.
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,255
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top