match and pull together

[Guest]

Here's an example of my spreadsheet

Column A Column B Column G Column H Column I
Bob Johnson w06102
Bill Smith w06777
Hal George w05834
Jim Branigan w06723 Sales Cent. 60W06 w05834
Dee Willclef w06289 Sales East 60W06 w06777
Steve Jackson w99041 Sales West 60w06 w06163
Sanjiv Gupta w88910 Underwrite 60W08 w06102

background: I pulled the data in columns G, H and I from a seperate
information source from the data in columns A and B. I pulled them into one
sheet to get them on the same page. - now I want to have something that
considers column B and looks to column I for a match, if it finds it, I want
to pull the info from that row ( the values G,H and I for the match) and
populate the data in the cells next to A and B - I want it to run down the
entire column B pulling in the match and populating all the way down.

Kind Regards,

 

[T. Valko]

Try this:

Assuming data in columns A and B start on row 2 and data in columns G, H and
I starts on row 5.

Entered in C2 and copied across to E2 then down as needed:

=IF(ISNUMBER(MATCH($B2,$I$5:$I$8,0)),INDEX(G$5:G$8,MATCH($B2,$I$5:$I$8,0)),"")

Biff