# Excel-can it do this??

fermerboy 23:45 30 Apr 04
Locked

Hi
I have to mark a valuation competition which is based like this. There are 4 articles marked A,B,X,Y, . These have to be placed in to the correct desending order and then points allocated as appropriate. The articles are marked prior to being valued so the correct answer can be any order.
What I have is a table with 24 columns and 24 rows(24 possible combinations)and further over a column of 24 possible scores. What I want to do is to have a formula which will look along the top row of the columns(titles)until it finds the one defined as correct by the correct answer cell(absolute reference?) then go down until it finds the same as the competitors answer cell and insert the score to match the answer.
Am I right in thinking that I need to use this lookup function to do this ?
I'm a beginer in the heavy excel stuff.
We have a fancy slide rule thing to do this just now but its really slow and I thought maybe the technology could do it

VoG II 23:52 30 Apr 04

If you want some more specific help you will need to define your worksheet structure in more detail. For example, where is a correct answer stored and what tells us that it is correct?

fermerboy 00:33 01 May 04

VoG
Thanks for your input I need time to study that download , I think Hlookup or Vlookup might be what I need.
What I intend to have is on sheet 1 cell A1 the correct answer for the competition, eg : ABXY or YXAB etc. On sheet 2 I have a list of competitors names in column A and the answer they gave in column B, column C will give the result as calculated. Sheet three will have a table 24 columns wide, 24 rows deep ,this gives all possible permutations of correct answer. So if the judge decides that ABXY is correct then I would then want to use the column with that at the top(correct answer) and follow it down till the competitors answer matches and then use the score on that row in the score column to go into the result for them in sheet2 col C.

VoG II 22:52 02 May 04

Any luck with this? One thought that struck me - could there be more than one correct answer - if so you need a VBA solution and a totally accurate description of your workbook.

fermerboy 00:55 04 May 04

VoG