Using an "indirect" formula without a cell reference

[crystalneedshelpplzthnx]

Hello,

I'm not sure if something like this is possible, but if "Indirect" is possible, I'm sure there is a way to achieve my goal. Here is my dilemma.

There is a formula I need to use: (formula 1)
=T:T&" "&IF(AA:AA<16,1,IF(AND(AA:AA>15,AA:AA<31),2,3))


Example output would be:
AM DIY 3.2OZ DÉC 1


I am able to achieve formula 1 by using another formula (it ends up looking just like formula 1): (formula 0)
="T:T&"" ""&IF(AA:AA<"&AU3&",1,2)"
AU3 changes depending on certain criteria


And then I line it up where the Example output would be using this formula (it ends up looking just like formula 1): (formula 2)
="="&VLOOKUP(T3,AE:AZ,22,0)


How do I make formula 2's output look like the output of formula 1?

Note:

I'm including pictures because the file it too large.

https://www.amazon.com/clouddrive/share/qRrFtZmS53r9NsvVO5gJ1K0nixHGR6GpYSAvGiUBOpi

Thank you!

 

[Special-K99]

re: Using an "indirect" formula without a cell reference

This

=T:T&" "&IF(AA:AA<16,1,IF(AND(AA:AA>15,AA:AA<31),2,3))

is not using the correct logic

IF(AA:AA<16 is FALSE then it MUST be > 15 so your formula should say

=T:T&" "&IF(AA:AA<16,1,IF(AND(AA:AA>=16,AA:AA<31),2,3))

which can be simplified to

=T:T&" "&IF(AA:AA<16,1,IF(AA:AA<31,2,3))

 

[crystalneedshelpplzthnx]

re: Using an "indirect" formula without a cell reference

Thnx so much for your response. Are you able to assist with the current dilemma concerning the formula output? That would be great if you could

Thank you!

 

[Special-K99]

Can you describe in words what youre trying to do?

 

[crystalneedshelpplzthnx]

I have a formula that I want to use. I am able to create this formula using different strings of data. Once I combine those strings of data, I want that concatenated formula to act as the original formula.

I'm sure that comes across clear as mud. But my reasoning is I have a short list (where all the information about this particular category is spelled out) I can easily manipulate, and I want that to update the longer list I don't care to manipulate one by one.

 

[crystalneedshelpplzthnx]

Here is spreadsheet.

https://www.dropbox.com/s/vj2l39roclugtjq/Indirect with no cell reference.xlsx?dl=0

 

[Behelith]

Change the value of cell AZ3 to:

=T:T&" "&IF(AA:AA<AU3,1,IF(AND(AA:AA>AV3,AA:AA<AW3),2,3))

Then drag the formula down to AZ19

 

[Behelith]

Better compare the output of two cells than the formulas of two cells with another formula.

Excel can sometimes work ones logic to such extremes that all our logic starts breaking, I'm speaking out of experience

 

[Special-K99]

Change the value of cell AZ3 to:

=T:T&" "&IF(AA:AA<AU3,1,IF(AND(AA:AA>AV3,AA:AA<AW3),2,3))

Then drag the formula down to AZ19

Looks like the forum has incorrectly displayed your post (that IF statement is incomplete), probably due to < > characters, place spaces before and after the < > characters.
There is another way to do this (I think) but I cant recall what it is.

 

[crystalneedshelpplzthnx]

Doesn't look like this one is doable. Thnx!