Using match to return value

C

crapit

Is it possible to use match to return value without reference to other
cells?
=IF(MATCH(H219,{"00","01","02","03","04","05","06","07","08","09"},0),<<return
corresponding value>> )

where corresponding value should return

"00" = Positve - Negative
"01" = Positve - Positive
"02" = Positive - Neutral
"03" = Negative - Positve
"04" = Negative - Negative
"05" = Negative - Neutral
"06" = Neutral -Positve
"07" = Neutral - Negative
etc ...
 

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

Returning a Date with Multiple Criteria Lookup Values 0
Too negative XIRR? 3
DIsplaying negative time values 1
max values in two ranges 4
count not-overlapping days in a "Table" with Beginning and EndingsDates Specified 0
Conditional Formatting 1
Find then highlight in yellow 6
reduce data points and average? 5

Top