how to use Ms Excel if()

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Describe the data and the required results.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting number of worksheets in a Excel 2007 1
Excel Barcoding using a central database repositories 0
MS Excel VBA Interview Questions & Answers 0
Import 4 Different Excel Files from One Folder 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
How to change text/font colour, using formula 2
Excel How to enable engineering functions in MS Excel 2000? 3
MS word Find and Replace using Regex - Help required 0

Back
Top