# if formula from another sheet?

Copper Contributor

# 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

# Re: if formula from another sheet?

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.

# Re: if formula from another sheet?

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!

# Re: if formula from another sheet?

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.