Hi guys, hopefully someone can help with this.
I'm using this function below:
=LOOKUP(C3,DATASHEET!$A$2:$A$111,DATASHEET!$F$2:$F $111)
Which works fine, it compares C3, to a new sheet, then grab the
appropriate column value in "F".
Now what I want to do it take C3 AND D3 on sheet1, then on the next
sheet (DATASHEET) find matching in the list for 2 Columns, say ColumnA
AND Column B. Then return the value in ColumnF.
Any ideas????
Thanks,
Stephen
--
Solarissf
------------------------------------------------------------------------
Solarissf's Profile:
http://www.excelforum.com/member.php...o&userid=34834
View this thread:
http://www.excelforum.com/showthread...hreadid=549595