Forum Discussion
if formula from another sheet?
i need to pull information from a cell on another sheet (sheet 2) onto sheet 1 based on criteria from another range of cells on sheet 2. i tried to do an if formula but i couldn't quite figure it out.
3 Replies
Could you please give bit more details how is your data structured and what is the logic used for selecting the cell. Better with screenshot or sample file.
i had to make a sample sheet because my original has private information on it. so i hope this makes sense. so on my first sheet will be all of my information and the 2nd sheet will be where i'd like specific information to be pulled over to keep track of certain items
so in this example if the order is "bag" i would like for the order # of that item to be pulled to the 2nd sheet where i will keep a total. i know i could easily type this information in but why do that when i can have a fancy formula lol. thanks for any help you can give!
Assuming Sheet1 setup is
and Sheet2
and since not sure on which Excel platform/version you are, formulae which shall work practically on all of them
in C3
=IFNA( INDEX( Sheet1!$D:$D, MATCH($B3, Sheet1!$B:$B, 0 ) ), "" )in D3
=IF($B3 ="", "", SUM($C$3:$C3) )and drag them down. Please check attached.
