how to use Ms Excel if()

R

reneabesmer

Hi ...
dear friends i have a problem with using Ms Excel if() , i need to use it
for multiple choices but Ms Excel allow us to use it seven time. while i need
it to use hundreds of times.i need to use in worksheet not in VBA.
 
P

Peo Sjoblom

Use a lookup table, for instance Vlookup, put the criteria in one column and
the result in another

=IF(A1="","",VLOOKUP(A1,B1:C100,0))

where the criteria values would be in B1:B100 and their associated results
adjacent in C1:C100
 
B

Bob Phillips

Describe the data and the required results.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top