Help on formula
I have two rows as below with the vlookup formula CALCULATING THE COST
Postcode No Pallets
AB 2 = £60
What I need is if ab = 200 then the above rule applies (£60) as a maximun to
overide the vlookup formula
I hope this is a bit clearer?
"Toppers" wrote:
Can you more detail of what you require? It appears to require an IF
statement but more info is needed.
"martin" wrote:
I have a vlookup formula that gives me a certain figure from a preset list,
but I need to be able to link this to a set criteria if the number equals
this or goes above then these figures take president over the vlookup answer
?????
|