Using If/And/Or formula to pull data from 2 different sheets into multiple cells

Question

Hi,

I'd like to pull data from 2 other sheets into my GRA Funding Sheet.

GRA Funding Sheet - should fill in the GRA information into the Current Sheet.

Details Sheet - pull all course information from here into Current Sheet

Current Sheet - this is the sheet I want all the info to come into (GRA Stipend Acct, GRA SHP Item Type, TA SHP, TA SHP Item Type).  The GRA information should pull from the GRA Funding Sheet, and the TA/course information should come from the Details sheet.  The problem is I can only have 1 formula in the column and this is what I currently have in there:

=INDEX({GRA Funding SHP}, MATCH([GRA Stipend Acct]@row, {GRA Funding StipendAcct}, 0))

Any ideas?  Hopefully, I've explained this clearly.  Basically, I'm thinking I'd prefer to have 1 column for SHP and one for Stipend and have it go to either other sheet based on selection of TA/GRA.

Thank you!!!

Lori

Philip Robbins · Answer

So would wrapping your INDEX/MATCH formula in an IF statement do it for you? Something like…

=IF(Type@row="GRA", INDEX({GRA Funding SHP}, MATCH([GRA Stipend Acct]@row, {GRA Funding StipendAcct}, 0)),"")

maineL · Answer

Yes this is what I'm trying to do. Get the GRA Stipend Account and GRA SHP Item Type to fill into the TA SHP and TA SHP Item Type but only if GRA or TA are selected in the Type column. I'm just not sure what to use for the formula…

Philip Robbins · Answer

Hi Lori,

If you're trying to pull data from two sheets into one column this is possible. You just need to write both formulas into the column with something like +" - "+ to join them. I've just double checked this with two INDEX/MATCH functions pointing to different sheets and it worked.

Have I understood your question correctly?