IF & Vlookup formula query

[Sundance_Kid]

I am trying to figure out a formula but cant get it fully right.

Cell A1 = Text saying USA

Cell B1 = Formula = If A1="Europe", vlookup(A1,'Sheet2'!A:C,3,0),otherwise return the text in cell A1

I cannot get the last part of the formula where I want it to return the text from cell A1 if it is not "Europe".

Thanks

 

[alansidman]

=if(A1="Europe",vlookup(A1,'Sheet2'!A:C,3,0),A1)

 

[Sundance_Kid]

=if(A1="Europe",vlookup(A1,'Sheet2'!A:C,3,0),A1)

Thank you, where you had ,A1 at the end of the formula I stupidly had it saying =A1

 

[alansidman]

You are welcome. Thanks for the feedback