Lookup and fetch from the same column

D

Dhruva101

I have spread sheet that has three columns, out of which two are pr
populated and I am finding the information for the third column fro
the other system.
Example :
Module-- Job---------- Owner
abc215-- AQ20DX
abc224-- ABG9DA
abc224-- ABG9DB
abc224-- ABG9DX
abc225-- AO14DX
abc225-- AO15DX
abc375-- AQ20DX
abf987-- ABG9DA
abh897-- ABG9DB
Click to expand...

Using the Job Name I get the information from the other system an
populate the info as follows.
Module-- Job-------Owner
abc215-- AQ20DX--14B
abc224-- ABG9DA--14E
abc224-- ABG9DB--14D
abc224-- ABG9DX--14E
abc225-- AO14DX--14E
abc225-- AO15DX--14E
abc375-- AQ20DX
abf987-- ABG9DA
abh897-- ABG9DB
Click to expand...

If you notice the last three rows of job names are nothing but th
first three rows. so the owner information for these three jobs als
same as the first three jobs. It can happen many times since man
programs can be executed by same jobs.

Now my requirement is: If the same job is repeated , can I have formul
to fetch the owner information and populate it on the owner column.

Now in this case, I would expect that the last three rows of the owne
information should be auto populated as follows since the owne
information is already identified above.
Module-- Job-------Owner
abc215-- AQ20DX--14B
abc224-- ABG9DA--14E
abc224-- ABG9DB--14D
abc224-- ABG9DX--14E
abc225-- AO14DX--14E
abc225-- AO15DX--14E
abc375-- AQ20DX--14B <== Auto populated
abf987-- ABG9DA--14E <== Auto populated
abh897-- ABG9DB--14D <== Auto Populated
Click to expand...


Can some one help me in this
 
B

Bob Phillips

How about, in the third row

=IF(NOT(ISNA(VLOOKUP(B3,$B$2:$C2,2,False))),VLOOKUP(B3,$B$2:$C2,2,False),"")

and copy down

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top