Forum Discussion

Copper Contributor

Aug 06, 2024

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...

excel

Formulas and Functions

SergeiBaklan

Diamond Contributor

Aug 06, 2024

Jessssssssss

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.

Jessssssssss

Copper Contributor

Aug 12, 2024

SergeiBaklan

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!

SergeiBaklan
Diamond Contributor
Aug 12, 2024
Jessssssssss

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.
if formula from another sheet.xlsx12 KB