Vlookup with IF

[Pumperkin]

Hi,

I am trying to do a Vlookup with IF, but just get a 0 answer rather than the result of the VLOOKUP.

I am trying to find (from a long list) the most expensive product in stock (the list includes in stock and sold items). I have a MAX(IF) array in cell K7 to find the highest value and am trying to find which product has that value.

The data itself is on a different sheet - the stock status is in Column 13 with the product details in Column 16 (however, the VLOOKUP starts in column 6 hence the number shifting).

I have the following formula:

=IF(Table3[Despatch Time]="Not Despatched", VLOOKUP(K7, Table3[[Cost]:[Model/Memory]], 11, ),)

Any ideas?

 

[etaf]

despatch time filed has various TEXT entries NOT time values ? and the TEXT "NOT DEPATCHED"
should that be
'NOT DESPATCHED"

 

[Pumperkin]

despatch time filed has various TEXT entries NOT time values ? and the TEXT "NOT DEPATCHED"
should that be
'NOT DESPATCHED"

Hi, Yes it should be "Not Despatched". This column has either a figure in days, or "Not Despatched".

I managed to get it to work - realised it's an ARRAY (Ctrl-Shift-Enter) oops...

Thanks for all your help :D

 

[etaf]

yes, sorry I'm on 365 on a mac and that automatically works out arrays now , so doesnt need the {} as it just works, should have remembered