Country look-up

[Peak Seagull]

Hi,

I need to extract the Country from ‘Sheet 1’ into the ‘Country’ column on ‘Sheet 2’ where there is match with the email address.

Can some smart person assist me with this – I’m sure it’s not difficult but I’m a bit brain dead today an am in need of assistance.

Thank you in anticipation.

 

[rollis13]

Is this what you are after ? in cell E4 of Sheet2:

=VLOOKUP(B4,Sheet1!B4:E14,4,FALSE)

 

[Peak Seagull]

That's brilliant - thanks ever so much for your help.

 

[rollis13]

Thanks for the positive feedback, glad having been of some help.

 

[Peak Seagull]

Hi, although it works perfectly on the dummy spreadsheet I sent with your formula I can't get it to work on my real spreadsheet - come up with the #NA!!

 

[Peak Seagull]

Got it to work now - thanks again.