Hello,
I am tring to use this get formula to return a values based on a cell refrence.
=IF(ISERROR(DGET(RatioCY!$A$1:$CR$10650,$A2,Inputs!$N$3:$O$4)),#N/A,DGET(RatioCY!$A$1:$CR$10650,$A2,Inputs!$N$3:$O$4))
ratiocy is a worksheet contains the data that i need to pull in. a2 is a cell that contains the number of the column which the specific cell i need to refrence inputs!n3:04 is the cell which contains a bank name which is what i want to match up so i can pull info from that row.
I know i am not doing the best job describing this..but basically i have the bank name in one cell then i want to use that to look up other information on the bank which is why i use the other cell which contains the column number
I have used this SAME formula in other excel spreadsheets to do the exact same thing.. but when i pasted it into this worksheet and changed the worksheet names it is not working.. ???????
PLEASE HELP..
I am tring to use this get formula to return a values based on a cell refrence.
=IF(ISERROR(DGET(RatioCY!$A$1:$CR$10650,$A2,Inputs!$N$3:$O$4)),#N/A,DGET(RatioCY!$A$1:$CR$10650,$A2,Inputs!$N$3:$O$4))
ratiocy is a worksheet contains the data that i need to pull in. a2 is a cell that contains the number of the column which the specific cell i need to refrence inputs!n3:04 is the cell which contains a bank name which is what i want to match up so i can pull info from that row.
I know i am not doing the best job describing this..but basically i have the bank name in one cell then i want to use that to look up other information on the bank which is why i use the other cell which contains the column number
I have used this SAME formula in other excel spreadsheets to do the exact same thing.. but when i pasted it into this worksheet and changed the worksheet names it is not working.. ???????
PLEASE HELP..