if calculation

  • Thread starter Thread starter frank
  • Start date Start date
F

frank

can you have a lookup function that occurs only IF another
cell is equal to a certain entry? hope this makes sense.
thanks

-frank
 
Frank,

Yes, its simple

=IF(A1=condition, VLOOKUP(etc.),"")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
So, kind of like...

=IF(C6=100,LOOKUP(C6,C6:U6),"C6 Not 100")

Or am I misunderstanding?

-Bob
 
Frank

Entered in B1(or wherever)......

=IF(A1="date",VLOOKUP(A2,C2:D31,2,FALSE),"")

Gord Dibben Excel MVP
 
Sure is

=IF(A1<>condition, VLOOKUP(etc.),"")

greater than or equal >=
less than or equal <=

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top