Excel 2007/2003 - Automated value entry
 

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

Excel 2007/2003 - Automated value entry
 

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
DTHIS
web: www.excelusergroup.org
web: www.nickhodge.co.uk





"Raj" wrote in message
...
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

Excel 2007/2003 - Automated value entry
 

Thanks,

It worked excellent.......

"Nick Hodge" wrote:

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
DTHIS
web: www.excelusergroup.org
web: www.nickhodge.co.uk





"Raj" wrote in message
...
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

Excel 2007/2003 - Automated value entry
 

Raj

Great

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.excelusergroup.org
web: www.nickhodge.co.uk





"Raj" wrote in message
...
Thanks,

It worked excellent.......

"Nick Hodge" wrote:

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
DTHIS
web: www.excelusergroup.org
web: www.nickhodge.co.uk





"Raj" wrote in message
...
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