Well, I have reached out to just about every excel guru I know, and can't get an answer to this one. I have two spreadsheets and I ultimately need to use an if/then to verify that there is a match between a peoplesoft output amount and one from historical records. One is in the form of a terribly made pivot table and the other is a list of earnings.
I was able to create a statement like
=IF(J11=GETPIVOTDATA("Total YTD Amount",Sheet2!$A$1,"Last Name","Abbott","First Name","Robin","Oracle Code","REG"),"Yes","No")
to get what I needed, but I can't autofill down a long row list.. Would anyone be willing to help? I can send the sheets I have and what I've come up with so far... whoever can help will forever hold my debt!
nate.scarritt@cerner.com
I was able to create a statement like
=IF(J11=GETPIVOTDATA("Total YTD Amount",Sheet2!$A$1,"Last Name","Abbott","First Name","Robin","Oracle Code","REG"),"Yes","No")
to get what I needed, but I can't autofill down a long row list.. Would anyone be willing to help? I can send the sheets I have and what I've come up with so far... whoever can help will forever hold my debt!
nate.scarritt@cerner.com
Ares: Used to be a God of War
(13 items) |
|
Ares: Used to be a God of War
(13 items) |
