Because of IF limitations, I need some helps.
I need a macro to update one cell value by comparing 3 ells.valu
against 8 cells.value. (3*8=24 conditions)

In plain english it is as below:

To update the (J10)cell.value,I need to compare B10 with K9:R9, C1
with K9:R9 & D10 with K9:R9.

e.g. If B10=L9,C10=R9 & D10=N9 then J10=284

The text value (284) comes from column
K=1,L=2,M=3,N=4,O=5,P=6,Q=7,R=8

The macro will update the column (J) if columns B:D are not empty.

Thanks
Michae

--
Message posted from http://www.ExcelForum.com