Need help looking up values in a different sheet

[Judo Tom]

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

 

[Aladin Akyurek]

On 2002-10-06 19:47, Judo Tom wrote:
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..

"t is not working" doesn't tell much...

Reduce the formula to

=DGET(RatioCY!$A$1:$CR$10650,$A2,Inputs!$N$3:$O$4)

and report back what the reduced formula returns.