Match ID from sheet 1 to sheet 2 and populate columns

[shortstuf028]

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

 

[shortstuf028]

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]

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
98	accepded
Course Dates

 

[scottylad2]

Excel Workbook
	H	I	J	K	L	M	N	O
77	Sheet 1			sheet 2			Sheet 3
78	842142	declined	x	818816	declined	o	768780	o
79	747260	pending	o	833675	pending	o	836997	x
80	841106	pending	x	818816	declined	o	747260	o
81	765436	pending	o	842142	declined	o	722878	o
82	822505	accepded	x	700830	accepded	o	841106	x
83	818816	accepded	o	841106	pending	o	700830	o
84	765158	pending	x	842142	accepded	x	836997	o
85	836294	declined	o	700830	accepded	o	700830	x
86	722878	declined	x	722878	accepded	o	746645	x
87	768780	pending	o	818816	accepded	x	822505	o
88	700830	accepded	x	722878	pending	x	833675	x
89	836997	accepded	o	765436	pending	o	842142	x
90	833675	accepded	x	836997	pending	x	700830	o
91	746645	pending	o	842142	pending	x	765436	x
92	782804	accepded	x	836294	pending	o	818816	x
93
94			Lookup >>	768780
95			pending	pending	x
Course Dates

 

[scottylad2]

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]

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.