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
 

Some videos you may like

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.

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


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.
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,106,922
Messages
5,514,193
Members
408,989
Latest member
tommo1949

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top