OK so I am having a problem. I have a program that populates a spreadsheet. I want to essentially summarize this information in a new sheet.
I have 7 cells of information that can be changed and need to cross reference this on my summary and pull the correct information from the data sheet to display what I need.
To clarify heres a shorter example:
"Summary"
A1: Red, Blue, Green
A2: Carl, Susan, Thomas (These cels are validated lists)
A3: a,b,c
B5: 1 C5:____
B6: 2 C6:_____
B7: 3 C7:_____
... and so on
on my "Data" sheet a row looks like
B1 C1 D1 E1 F1
Red Carl b 1 Apples
What I want to do is get cell C5 in "Summary" to say "Apples"
what I tried to do is in Column A of sheet "Data" was
= $B$1&$C$1&$D$1&F&1
and then for my equation for cell C5 was
=IFERROR(VLOOKUP($A$1&$A$2&$A$3&$B5,DATA!(full range),6,FALSE),"Not Found")
the 6 is for cell F1 where apples should be.
What am i doing wrong?
So sorry if this is confusing, I can definitely clarify if needed.
Best.
I have 7 cells of information that can be changed and need to cross reference this on my summary and pull the correct information from the data sheet to display what I need.
To clarify heres a shorter example:
"Summary"
A1: Red, Blue, Green
A2: Carl, Susan, Thomas (These cels are validated lists)
A3: a,b,c
B5: 1 C5:____
B6: 2 C6:_____
B7: 3 C7:_____
... and so on
on my "Data" sheet a row looks like
B1 C1 D1 E1 F1
Red Carl b 1 Apples
What I want to do is get cell C5 in "Summary" to say "Apples"
what I tried to do is in Column A of sheet "Data" was
= $B$1&$C$1&$D$1&F&1
and then for my equation for cell C5 was
=IFERROR(VLOOKUP($A$1&$A$2&$A$3&$B5,DATA!(full range),6,FALSE),"Not Found")
the 6 is for cell F1 where apples should be.
What am i doing wrong?
So sorry if this is confusing, I can definitely clarify if needed.
Best.
