VLOOKUP formula will not work

[Cornelius deWeever]

I am trying to map data from another sheet, I am using VLOOKUp, only using one column, and instead of inputting the right information. it shows up as

=VLOOKUP('Combined LIU & Ironshore'!L2,'Combined LIU & Ironshore'!L:L,1,false)



Does this mean the formula isn't right? It's a very basic formula so I am not sure what is the issue with it.

THANKS!

 

[pecoflyer]

Is calculation set to automatic?
I might be wrong but your formula will alwys return L2 as you are searching L in the entire L column

 

[AliGW]

Why are you not simply using this:

='Combined LIU & Ironshore'!L2

We need more detail. Attach a sample workbook and manually mock up what you want.

 

[GraH - Guido]

might be ...
A circular reference. The lookup key (L2) and the lookup column (L:L) are both referring to L column on the same sheet.
+ Formula shows as text when column data type is defined as text. See in format.
+ What Ali says. Upload your workbook, please.