What formula should I use?

[Maddy4444]

Can someone please help? I have this data in excel 10 and I’ve copied and pasted values from 2 diff databases into one worksheet for comparison. Currently my columns are laid out horizontally and the following data is entered
A. account numbers 16023-74530 ascending order from database 1
B general ledger
C portfolio code
D (I want 1st set return values here )
E (I want 2nd set of return values here )
F account numbers 1000-8000 from database 2
G Y/N in the column referring to the Acct number in column F and if it’s an account that needs reconciling (Y for yes and N no)
Basically columns A-C represent data from one database or source and im comparing Them with another column of data from another source (columns F-G)
D and E is where I want the results to land.
I want a formula that says look in column A for an account number and go to column F and find it. If it exists then put that account number in column D and if it doesn’t then do nothing. The second result I need goes in column E. If that account number exists in column D then I need to know if it’s a reconciling account based on column G. Ultimate result :
Column A is my account number that I need to search and find in a list of account numbers located in column F and not all those accounts in column A will be found so use column D to tell me if there’s a match but I also need to know if this account needs to be reconciled. Column G!!! Please help! I think it’s a INDEX formula but I don’t know how or where to start! Any input would be greatly appreciated
Maddy

 

[AhoyNC]

Maybe something like this.

Copy formulas down as needed.

Excel Workbook
	A	B	C	D	E	F	G
1	Acct#	GL#	Port Code	Found	reconciling	Acct# 2
2	16023					15000	Y
3	16024					16025	y
4	16025			16025	y	16026	n
5	16026			16026	n	16027	n
6	16027			16027	n	16028	y
7	16028			16028	y	16029	y
8	16029			16029	y	18000	y
9	16030					18002	n
10	16031					16032	n
11	16032			16032	n	16033	y
12	16033			16033	y	16034	y
13	16034			16034	y	20000	y
14	16035					16036	n
15	16036			16036	n	16037	y
16	16037			16037	y
Sheet

 

[Maddy4444]

This is much appreciated! Thank you so much for your help!

 

[AhoyNC]

You're welcome. Thanks for the feedback and welcome to the forum.