Vlookup Problem

LJC

New Member
Joined
Nov 25, 2008
Messages
25
Hi,

Hope someone can help. I have a cell A2 (product code) that refers to another cell in another spreadsheet. ='Test TY £'!A2

This cell (A2) is then used in my Vlookup formula to find that product code in another spreadsheet.

However, it returns N/A# when it shouldn't. I do not want to copy and paste special the values as I do need to keep the ref i.e.='Test TY £'!A2

Any way around this other than having a column with the values and hiding that column?

Regards
 

Some videos you may like

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

schielrn

Well-known Member
Joined
Apr 4, 2007
Messages
6,934
Are there maybe leading spaces somewhere in the data? Or is one formatted as a number and the other formatted as text maybe?

What is the value that is in A2 currently?
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,106,017
Messages
5,508,826
Members
408,696
Latest member
stunik94

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top