Have one data table with 200+ codes<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
<o> </o>
The data table looks like this<o></o>
code # bit mfg bit type<o></o>
2001 HTC E5001FG<o></o>
<o></o>
Main worksheet<o></o>
<o> </o>
In the main table (see image) I want to look up the code# biased on the information in columns e & f and place the code# in column d<o></o>
http://img99.imageshack.us/img99/5581/excel1.png
<o> </o>
<o> </o>
The data table looks like this<o></o>
code # bit mfg bit type<o></o>
2001 HTC E5001FG<o></o>
<o></o>
Main worksheet<o></o>
<o> </o>
In the main table (see image) I want to look up the code# biased on the information in columns e & f and place the code# in column d<o></o>
http://img99.imageshack.us/img99/5581/excel1.png