anewday777

New Member
Joined
Jan 23, 2017
Messages
8
Im inputting this formula but it is not pulling the result

=VLOOKUP(B2,Sheet1!A120:D136,4,FALSE)

It gives a result of N/A
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

LouisT

Board Regular
Joined
Apr 5, 2010
Messages
61
can you give us a sample of what is in B2 as well as the Range?
 

anewday777

New Member
Joined
Jan 23, 2017
Messages
8
b2 has terminal id
P361985

<tbody>
</tbody>

<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
P361985

<colgroup><col></colgroup><tbody>
</tbody>
</body>
 

anewday777

New Member
Joined
Jan 23, 2017
Messages
8
TerminalNameMachine TypeInstall Date
P392607 TRISTATE ATM HSPC 2583000 (Standard 3 DCC) GenMega7/24/18
P392608 TRISTATE ATM TBF 2592500 (Standard 3 DCC) GenMega7/24/18
P394659 TOWNPLACE SUITES BY MARRIOTT 0382500 (Standard 3 DCC) GenMega8/10/18
P395722 PLANO MUNICIPAL COURT 2842700 (Std 3 on P5)Hyosung8/31/18
P395723 PSA MURPHY 057Halo (Std 3 on P5)Hyosung8/25/18
P395724 BELLEZZA WINDHAVEN 0625000 (Std 3 on P5)Hyosung8/25/18
P395725 JESUIT 0632700 (Std 3 on P5)Hyosung8/30/18
P395726 TRANS AMERICA 0672700 (Std 3 on P5)Hyosung8/31/18

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
 

anewday777

New Member
Joined
Jan 23, 2017
Messages
8

ADVERTISEMENT

both sheets show tid, i was using tid and looking at other sheet to find the tid and return the install date
 

LouisT

Board Regular
Joined
Apr 5, 2010
Messages
61

ADVERTISEMENT

Based on this information and what you're trying to return, there's only a couple reasons for the N/A

1 - The range and or reference is wrong(unlikely i assume)
2 - The TID is actually not in the list
3 - The TID reference and the TID in the range are perhaps not formatted the same and/or one has perhaps a Space in it. example "P361985" in one cell but "P361985 " in another.

Make sense?
Louis T
 

sturnusek

Board Regular
Joined
Sep 20, 2018
Messages
51
If you are using Power Query, make sure you identified the column as a text/number. If you are using this formula in more than one place, make sure you lock the range using the $ signs, as if you drag it down it will change.
 

anewday777

New Member
Joined
Jan 23, 2017
Messages
8
I have another spreadsheet it works fine on the formulas different data but still using tid.....for some reason.....i still cannot get it to work
 

LouisT

Board Regular
Joined
Apr 5, 2010
Messages
61
I'd check specifically that data. the only thing that makes sense is that there's an extra/different character in the string.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,380
Messages
5,528,357
Members
409,817
Latest member
JiNXX9500

This Week's Hot Topics

  • Change military grades into rank
    Afternoon all Need help with formula that will change military rank (i.e. 1, 2, 3 into Amn, A1C, SrA). Running IF formula that does not work...
  • VBA COUNTIF SOLUTION
    Hi The following are the errors spread across the several columns from E to Q ie. 13 columns across several sheets with more than 500 rows per...
  • INSERT ROW WITH SPECIFIS TEXT IN A COLUMN
    Hi All! How can identify that that the row to be inserted has to be inserted before 1st row with specific text in column F. If I record the...
  • Auto-Create a monthly Sign in sheet for preschool students
    The image below is what each page looks like. Above is space for the "Child Name" "Month" "Class" School days are obviously Monday-Friday but...
  • VBA vlookup multiple results
    Hi folks, Hopefully someone out there can help. I have a list to vlookup which works (ish). the lookup only picks up the first instance of the...
  • Extract values for earliest/latest times
    I am trying to put together a formula to get the earliest start time, the latest end time from column A for each person in Column B-F without the...
Top