Vlookup using a Cell with a Vlookup already

[Don Fardie]

I’m using a Vlookup formula and the cell I’m using as the Look_Up value is a cell that has aVlookup formula already assigned to it. I keep getting Error and I’m wonderingif it is because the cell I’m referencing is not returning a true value? <o></o>
This is the formula I’m using in F8 =VLOOKUP(Q6,Sheet2!B4:C32,2,FALSE)(Using Q6 as my Look UP value). Cell Q6 has this formula already assigned to it =VLOOKUP(D6,Sheet2!I14:J15,2,FALSE)
Thanks in advance for any help..........Don

 

[Aladin Akyurek]

VLOOKUP(Q6,Sheet2!B4:C32,2,FALSE)​

is perfectly admissible even if Q6 houses

VLOOKUP(D6,Sheet2!I14:J15,2,FALSE)

which is also admissible.

What does the second VLOOKUP return - text or number?​

 

[Don Fardie]

Both Vlookups are returning TEXT. I don't understand either why it doesn't work????

 

[Marcílio_Lobão]

Dom Fardie, Good afternoon.

Master Aladin Akyurek, Good afternoon.

Dom, to avoid error messages when there is no positive answer try to use the formulas as well.

F8 --> =IFERROR( VLOOKUP(Q6,Sheet2!B4:C32,2,FALSE), "")

Q6 --> =IFERROR( VLOOKUP(D6,Sheet2!I14:J15,2,FALSE), "")

Is that what you want?
I hope it helps.

 

[Aladin Akyurek]

Both Vlookups are returning TEXT. I don't understand either why it doesn't work????

Does this perhaps work, i.e. get a hit?

VLOOKUP("*"&TRIM(Q6)&"*",Sheet2!B4:C32,2,FALSE)

 

[Don Fardie]

Sorry guys nothing is working. I've got to have something wrong somewhere!!! If I type the word in another cell and use that as the Look Up value it works!!

 

[Aladin Akyurek]

Sorry guys nothing is working. I've got to have something wrong somewhere!!! If I type the word in another cell and use that as the Look Up value it works!!

What is the word?

 

[Don Fardie]

Still trying!! Like I said if I type the same word it returns Q6 in another cell and use that new cell as the Look_Up value the formula works!! Stumped!!

 

[Marcílio_Lobão]

Don,

Whitout an example it's hard to help you conclusively.
Try to save you file at free site, www.sendspace.com and put a link to download here.

There is a little example about your explanation.
https://www.sendspace.com/file/z4qopf

Waiting for you answer.

 

[Don Fardie]

Ended up using a Data Validation to choose the correct text required and it works fine. Not sure why it didn't work with your inputs, but want to thank you both for your help!..........Don