I hope Im phrasing this right.


Heres my data table

======W X Y Z N
A B C D 1 2 3 4 5
E F G H 6 7 8 9 10


The letters are the search variables and the numbers are potential
outputs.

I want to be able to input, (A,B,C,D, W) and get an output of 1
(A,B,C,D,X)=2
(E,F,G, H,W)=6

how do i do this?


--
Fotop
------------------------------------------------------------------------
Fotop's Profile: http://www.excelforum.com/member.php...o&userid=27880
View this thread: http://www.excelforum.com/showthread...hreadid=525988