If statement with more parameters

  • Thread starter Thread starter rekoop
  • Start date Start date
R

rekoop

Hello,
My column A contains over 300 unique ID codes with over
15000 entries. I would like to set up a statement that
operates like the IF statement to place a numerical value
in column B based in the unique identifier in Column A.
I realize that that the If statement is limited to
7 "if's" so it is out of the question.
Also, the unique ID codes and corresponding numerical
data is hardcoded in a separate workbook. Can I use it
to help me?

All suggestions are very much appreciated.
 
rekoop wrote...
My column A contains over 300 unique ID codes with over 15000
entries. I would like to set up a statement that operates like
the IF statement to place a numerical value in column B based in
the unique identifier in Column A. I realize that that the If
statement is limited to 7 "if's" so it is out of the question. Also,
the unique ID codes and corresponding numerical data is
hardcoded in a separate workbook. Can I use it to help me?
Click to expand...

See VLOOKUP in online help
 

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

If statement 2
IF statement to check for numerical value 3
Simple nested if and statement 2
Creating a dynamic IF statement 2
Duplicates-to id when occurs in 3 columns for unique dup in 4th co 1
Nesting more than 7 IF statements (Excel 2003) 7
ACCESS - how do I apply a IIF = statement without parameter value prompt. The two column comparison is count 1
countif where condition should be met 3

Back
Top