Excel 2007/2003 - Automated value entry

[Raj]

Hi,

Please refer the table below

Priority Excellent Average Needs Improvement Poor
High 8 6 4 2
Medium 6 4 3 2
Low 5 4 3 2

I've maintained another excel sheet which has 3 colums by names Results,
Priority and Scores.
When i enter Excellent and Medium in respective Colums Results and Priority,
it should fetch the Scores from the above table as 6.

Please help

 

[Nick Hodge]

Raj

How about

=HLOOKUP($A$6,$B$1:$E$4,MATCH($B$6,$A$2:$A$4,0)+1,FALSE)

Table in A1:E4, Achievement in A6, Priority in B6, formula in C6

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.excelusergroup.org
web: www.nickhodge.co.uk

 

[Raj]

Thanks,

It worked excellent.......

Raj

How about

=HLOOKUP($A$6,$B$1:$E$4,MATCH($B$6,$A$2:$A$4,0)+1,FALSE)

Table in A1:E4, Achievement in A6, Priority in B6, formula in C6

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.excelusergroup.org
web: www.nickhodge.co.uk

 

[Nick Hodge]

Raj

Great

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.excelusergroup.org
web: www.nickhodge.co.uk