Populate Cell based on Vlookup

[urban_player]

Hi,

I am trying to achieve the following:

I have a row of data with multiple columns. I want to look up Column C for a value in another table, and if that value is found, i want it to return the contents of Column A (second table).

Column C is missing a field, i want to essentially find Cell B2 in table 2, if there is a match, return the missing blank in Table 1 C3 with the contents from table 2.

Table 1

A B C D E F
1 Jack jack@who.com XXX
2 Bob bob@who.com XXX
3 Dave dave@who.com
4 Jake jake@who.com XXX
5 Bob

Table 2
A B C D E F
1 Jack jack@who.com XXX
2 Bob bob@who.com XXX
3 Dave dave@who.com XXX
4 Jake jake@who.com XXX

Any help would be appreciated.

many thanks!

 

[Fluff]

How about

=INDEX(Sheet2!$A$2:$A$100,MATCH(B2,Sheet2!$B$2:$B$100,0))

 

[urban_player]

Hi Fluff,

thank you for your post.

How would i change the column it looks up and returns?

Do the table arrays need to be an exact match?

Above image, need to populate table two last row with EEEE, based on the table 1 column A being present.

 

[Fluff]

How would i change the column it looks up and returns?

Just change the ranges to suit

Do the table arrays need to be an exact match?

Yes they do.