Using a cell with a formula in it for lookup value
Still no values. What's sheet 2!A2? What's sheet 2!Q2?
What's in column A of your lookup table?
On which sheet is the VLOOKUP formula?
Please be precise
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"homuncula" wrote in message ...
| The table is not sorted, so I'm appending "false" which I understand
| should solve that problem.
| Here's the primary formula:
| =VLOOKUP(A2,'sheet 1'!A:F,6,FALSE)
|
| The formula inside A2 (the lookup value) is:
| =IF('sheet 2'!Q2=FALSE,TRIM('sheet 2'!A2),0)
|
|
| Thanks
|