getting ref error

[sksanjeev786]

Hi Team

I am using the below formula and getting #Ref!error "=IF(OR(RIGHT(INDIRECT(D2),1)="r", RIGHT(INDIRECT(D2),1)="p", RIGHT(INDIRECT(D2),1)="q"), RIGHT(INDIRECT(D2),1), "")"

Can anyone help me on this

 

[etaf]

why are you using an indirect ?
need to see the data and explain what you are actually trying to do

indirect(d2) will give an ref error

looks like you are just looking for the last character in a string
and only showing the or and not all the IF , there is no FALSE, and the OR is not finished with a bracket and not making sense to me - sorry

this bit as well
RIGHT(INDIRECT(D2),1), "")"
not sure what that is doing

 

[etaf]

is D2 a table reference list - to output the contents of a table name ???

as shown here - using indirect(d11)

Is it possible to create a dropdown list Based on named tables?

I have 3 tables: Table_1, Table_2, Week_3 All 3 tables are of the same structure and format. The only difference being the data contained in the tables. Is it possible to create a dropdown list that would give me a list of the 3 tables, THEN populate a worksheet with the appropriate data...

www.mrexcel.com

 

[sksanjeev786]

why are you using an indirect ?
need to see the data and explain what you are actually trying to do

indirect(d2) will give an ref error

looks like you are just looking for the last character in a string
and only showing the or and not all the IF , there is no FALSE, and the OR is not finished with a bracket and not making sense to me - sorry

this bit as well
RIGHT(INDIRECT(D2),1), "")"
not sure what that is doing

Thanks for checking on this! i got the solution

 

[etaf]

you are welcome
it may be worth posting the solution here - so anyone searching for a similar issue may see the solution on this forum