if formula mixed with vlookup

[johny]

As you all see I have the most
confusing problems
because data validation doesnt work with
cells that have forumlas Im trying to figure out a custom approach

So I need a formula something like this
=if(vlookup,a1,A6:a20,2)>activecell im changing
I need to look up the name and then choose
col 2 to compare that cell Thanks for anyones Help John

 

[ElectricSkywalker]

Jonny,
not sure exactly what you are asking for, however I am often using vlookups and if statements together. Below is an example of what I have been using.

One of the methods I have been having success with, is to first Concatenate cells, and then use them as a vlookup. It sometimes helps with the doubling up of formulas.

The below formula is simply an example of how i use the two together:


=IF(ISERROR(IF(Y$27<=$X$3,VLOOKUP(C59,'TRIAL BALANCE DUMP'!$G:$O,7,FALSE),IF(Y$27>$X$3,VLOOKUP(C59,'G:DATAAccountsCorporateBudget 2003Reporting 2002-2003PRO MANAGEMENT AUTOMATION[Corporate Budget 02-03 v2.xls]Board '!B:AL,17,FALSE)))),0,IF(Y$27<=$X$3,(VLOOKUP(C59,'TRIAL BALANCE DUMP'!$G:$O,7,FALSE))/1000,IF(Y$27>$X$3,(VLOOKUP(C59,'G:DATAAccountsCorporateBudget 2003Reporting 2002-2003PRO MANAGEMENT AUTOMATION[Corporate Budget 02-03 v2.xls]Board '!B:AL,17,FALSE))/1000)))

Cheers,
Greg

 

[johny]

Thanks for the formula
I need something that is reversed
vlookup find the name and check column 2
so when I add this in validation it
actualy is comparing col 2
your formula compares first then vlookup
i need vlook then compare Please help if you can JOhn Thanks

 

[Juan Pablo González]

John, it's not clear what you're after, or how your data is setup. Can you post some example data along with expected results ?