Insert value from cell when three conditions in row are met

Hi Thread -- I’m approaching failure in my quest to write an IF/THEN formula in Excel. Doh! I think my logic is there, but I'm searching for the right commands and order of operations.

IF CELL “A2” MATCHES CELL IN RANGE “DATABASE!A:A”,
AND IN “ROW WHERE “A2” MATCHES CELL IN RANGE “DATABASE!A:A””, “DATABASE!B$” = 2003,
AND IN “ROW WHERE “A2” MATCHES CELL IN RANGE “DATABASE!A:A””, “DATABASE!C$” = 1,
THEN, “=DATABASE!E$” OF THE ROW WHERE “A2” MATCHES CELL IN RANGE “DATABASE!A:A”, ELSE = -99.

Any and all help is appreciated.

For context, the reference database contains 10 years of quarterly earnings data for several thousand ID’s, laid out in panel/repeated measures/long format. An ID only includes quarterly earnings data for quarters in which there is a record of earnings. I am working to transpose this reference database into a wide-format database that indicates: (1) if that ID had any earnings for in each of the 40 possible earning quarters; and (2) if yes, what their earnings were. A sample workbook is provided below.

you probably need to change your question title

Please read and adhere to these simple rules!

1. Use concise, accurate thread titles. Your post title should describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

i dont follow your question


Please upload a small clean sample of your data / workbook (not a picture) to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
We would like to see an example of your data and also a manual mock up of the expected results you want to achieve.

To attach a file to your post,
click "Go advanced" (next to quick post),
scroll down until you see "manage Attachments",
click that and select "Choose File" (top Left corner).
Find your file, click "Open" click "upload" click 'close windows" Top Right. click "Submit Reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

a pivot table will do this for you

see attached - sheet called PVT-etaf

but will not show the -99 - not sure where that comes from

i'm afraid i dont work with VBA here - sorry