Multiple IF criteria

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

Guest

I have a spreadsheet that is just ghastly to work with. One row of data can
have up to 7 possible choices and of those choices the codes that have to be
entered crosswalk to a different set of reporting codes. I was thinking of
using an IF command but how do I do this when I have 7 possible criteria?

I don't like copying/pasting as the list is quite lengthy nor do I want to
have to filter and copy/paste either. The example I have is say a cell, say
A1 has data: abcd - efgh and the crosswalk number for this exact set
is 001 2 3455 (with spaces between numbers). I have to submit this report
quarterly to the State and I can't take it anymore!! Any help is
appreciated. Thanks in advance. Karen
 
Karen,

Could you use a VLOOKUP function?

For instance.
Have a sheet with 2 columns...one would have abcd - efgh and the other would
have 001 2 3455. Then on your report, you could just use a VLOOKUP function
in the column next to the value you need to reference and it would return the
correct value.
 
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

Extracting the last word from a string. 2
Access Dcount (multiple criteria) 3
Datatype mismatch in criteria expression 3
2-criteria query; 2nd criteria not regular 1
Sum If on multiple columns with range of criteria 1
Double IF - is this possible 3
Mapping 2 fields in one table to one field in another 2
Countif with multiple criteria (incl. calculation) 3

Back
Top