IF statement - pull data based on criteria

[Nikhil R]

Hi team,

I need some help a little bit. Trying various methods to pull data from one table onto another table in another sheet.

For example, one Column has Interested as a header, and if Yes - to pull candidate name into another table that's on another sheet with the same header under candidate name and vice versa for post code number and email address.

If it's not clear, please let me know

 

[Sufiyan97]

Not fully got your query

Do you want something like?

Book2
	A	B	C	D	E	F	G	H	I
1	Table1					Table2
2	Name	Code	Email	Pull info		Name	Code	Email
3	A	A123	Email1	Yes		C	C456
4	B	B234	Email2	No		B
5	C	C456	Email3	Yes
6
7
Sheet4

Cell Formulas
Range	Formula
G3:G4	G3	=IF(VLOOKUP(F3,$A$3:$D$5,4,0)="yes",VLOOKUP(F3,$A$3:$D$5,2,0),"")

 

[Fluff]

Can you post some sample data showing what you have & what you want.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[Nikhil R]

Not fully got your query

Do you want something like?

Book2
	A	B	C	D	E	F	G	H	I
1	Table1					Table2
2	Name	Code	Email	Pull info		Name	Code	Email
3	A	A123	Email1	Yes		C	C456
4	B	B234	Email2	No		B
5	C	C456	Email3	Yes
6
7
Sheet4

Cell Formulas
Range	Formula
G3:G4	G3	=IF(VLOOKUP(F3,$A$3:$D$5,4,0)="yes",VLOOKUP(F3,$A$3:$D$5,2,0),"")

Apologies,

Something like this. So on the interested candidates sheet, if the interested column is "Yes", then i'd like to have the candidate name; post code; number and email address automatically inputted onto the candidate tracker sheet for the relevant columns

 

[Nikhil R]

Can you post some sample data showing what you have & what you want.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

Ah yeah I'm not able to due to using a work laptop & can't download anything unfortunately

 

[Fluff]

Will canditates ever bee removed from the 1st sheet, the data ever be sorted or the Interested ever be changed from Yes to No (or vice versa)?

 

[Nikhil R]

Will canditates ever bee removed from the 1st sheet, the data ever be sorted or the Interested ever be changed from Yes to No (or vice versa)?

Candidates could potentially be changed from Yes to No, and vice versa.
I'll be turning the candidates red / green should they be interested or not respectively or rejected during the qualification call which I know how to do

 

[Fluff]

Candidates could potentially be changed from Yes to No, and vice versa.

In that case any data you put in the 2nd table will get messed up, as it may not be in the correct row.

 

[Nikhil R]

In that case any data you put in the 2nd table will get messed up, as it may not be in the correct row.

Yeah i thought about that, let's keep it simple for now and I'll see as i go along. if need be i can just manually re-add candidates again but for now our qualification is always good on the first instance.

so just if interested column is yes, then the like for like details on candidate tracker automatically inputted

 

[Fluff]

Removed as formula was wrong