Double lookup

  • Thread starter Thread starter ibo
  • Start date Start date
I

ibo

Hi
I am using Excel xp and I have a two shhets below formula.

=IF(OR(VLOOKUP($C$3;Database;27;0)="-";ISBLANK(VLOOKUP($C$3;Database;27;0)))
;"";VLOOKUP($C$3;Database;27;0))

Is it possible to modify this formula If look to from same database if
column 21 is "700muh" use above formula .If column 21 is "DZkk" use Column
25*26....like vlookup($c$3;Database;25*26;0)

Is it possible?

Thanks for advance

Ibo
 
Ibo,

Do you mean a lookup into column 21 is 700muh, or a value in one cell in
column 21 is 700muh?

If the former, use a test like
=IF(VLOOKUP($C$3,Database,21,0)="700muh", existing formula, new formula)

If the latter, same principle, but no lookup
=IF(U1="700muh", existing formula, new formula)
 
Glad to help.

Regards

Bob

ibo said:
Many many thanks Bob,
I tried first one, It works you are great....


=IF(OR(VLOOKUP($C$3;Database;27;0)="-";ISBLANK(VLOOKUP($C$3;Database;27;0)))
Click to expand...
 
Back
Top