Match ID from sheet 1 to sheet 2 and populate columns

shortstuf028

New Member
Joined
Jul 28, 2010
Messages
3
Hi

So far I have the following formula:

=IF(AND(B:B='Category 3 - Accepted'!B:B,'Category 3 - Accepted'!H:H="Approve",Z7="x"), "A","")

What I'm trying to do is have excel populate the fields from my Category 3 sheet to the current sheet based on the ID # (which is in column B on both sheets) and the presence of the x in Z. Right now this formula works, but only if the ID # is in the same row on both sheets. I need it to work regardless of the row it's in because it will likely never match up.

PLEASE HELP!!!

Thanks
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

shortstuf028

New Member
Joined
Jul 28, 2010
Messages
3
There's got to be a way to do this. I want the fields to populate with information from the other sheet when the ID # is typed into the first sheet.
 

scottylad2

Well-known Member
Joined
Feb 2, 2009
Messages
1,919
I'm not entirley sure what your trying to do, but would a vlookup not do as you wish?

1 for each sheet, but looking up the same value

Excel Workbook
K
98accepded
Course Dates
 

scottylad2

Well-known Member
Joined
Feb 2, 2009
Messages
1,919
Excel Workbook
HIJKLMNO
77Sheet 1sheet 2Sheet 3
78842142declinedx818816declinedo768780o
79747260pendingo833675pendingo836997x
80841106pendingx818816declinedo747260o
81765436pendingo842142declinedo722878o
82822505accepdedx700830accepdedo841106x
83818816accepdedo841106pendingo700830o
84765158pendingx842142accepdedx836997o
85836294declinedo700830accepdedo700830x
86722878declinedx722878accepdedo746645x
87768780pendingo818816accepdedx822505o
88700830accepdedx722878pendingx833675x
89836997accepdedo765436pendingo842142x
90833675accepdedx836997pendingx700830o
91746645pendingo842142pendingx765436x
92782804accepdedx836294pendingo818816x
93
94Lookup >>768780
95pendingpendingx
Course Dates
 

scottylad2

Well-known Member
Joined
Feb 2, 2009
Messages
1,919
Not all of my post is showing, but essentially theres a Vlookup for each sheet in the answer cells, all referencing the same lookup number which is in different rows in each sheet.

If it's just a straight Vlookup for each instance of the number then above should suffice, but if you need criteria added, like in an =Ifxx=xx,Vlooku( then that should be easy enough...just not able to do it right now as my sheets not displaying on the board proper
 

shortstuf028

New Member
Joined
Jul 28, 2010
Messages
3
0B4z1nuqtDxycN2IzZDJjYTUtNWI2NS00NzI0LWI0OGQtMDBiODkzMzBiM2I5


This is the master sheet I'm trying to get the information on. The blue cells will be typed in and the yellow cells I want to automatically fill from the other sheet in the workbook. The application ID is what I want to type in on this sheet and have the formulas in the yellow cells pull the correct information from the other sheet. I think I might need to add the lookup formula somewhere into my formula? As I said earlier, my formula is working as long as the application IDs are on the same row on each of the tabs. Ex. if application 12345 is on row 2, it has to be on row 2 on the second sheet and the information is pulling correctly.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,918
Messages
5,834,370
Members
430,281
Latest member
fabcat1

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
Top