Hi
you may use a helper column with the following array formula (entered
with CTRL+SHIFT+ENTER) in cell D1 on your lookup sheet:
==IF(ISNA(INDEX('code'!$C$1:$C$1000,MATCH(A1&B1,'c ode'!$A$1:$A$1000&'co
de'!$B$1:$B$1000,0))),C1,INDEX('code'!$C$1:$C$1000 ,MATCH(A1&B1,'code'!$
A$1:$A$1000&'code'!$B$1:$B$1000,0)))
and copy down for all rows

--
Regards
Frank Kabel
Frankfurt, Germany

"Doug Van" schrieb im Newsbeitrag
...
I have two tabs on a spreadsheet, one called import and the other
called
lookup.

I need to update one of the column in the lookup table based on a
match.

For example

Import has three columns
Job
State
Code

Lookup has three column
Job
State
Number

If want to search for a match on Job and State. If there is a match,
update
the Number column (lookup) with the value in Code (Import).

Would the lookup function be the best way? I think I am close, I
just need
someone to point me in the right direction.

Thanks