How to get reult in text

G

Guest

Hi guys, first time user of this service, and only a novice excel user. But
if someone could help me with this problem I would be grateful.

I currently have a Risk Rating matrix that looks like this

insignificant minor moderate
Almost Certain LOW MEDIUM HIGH
Likely VERY LOW LOW MEDIUM

and so it goes on with 5 columns (the Consequence) 5 rows (The Likelihood).

Now what I wnt to do is this,

within the table I want to be able to select a likelihood & a consequence
within specific cells and then the corresponding risk rating to come up. Now
I understnad that this is all textual and that excel is predominently
numerical, and such a formula would be easier in Ms Access. however working
for a cheap arse government department they wont purchase it. so i am stuck
in excel.

Any ideas?

Thanks
 
B

Biff

Hi!

Assume the table is in the range A1:D3

A10 = likelihood
A11 = consequence

=VLOOKUP(A10,A1:D3 MATCH(A11,A1:D1,0),0)

Biff
 

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

3 text lookup tables use to define contents of a cell 3
colour cells using VBA 2
Trying to get cells to reference a 5x5 matrix 1
Focus problem?? 3
Risk & Issue Register and risk maps 9
How to get result? 4
This Mail Changed My Life: 2
History of Xbox 360 defects - Dean Takahashi has the inside story(long) 2

Top