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
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

LouisT

Board Regular
Joined
Apr 5, 2010
Messages
63
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
63

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
63
I'd check specifically that data. the only thing that makes sense is that there's an extra/different character in the string.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,299
Messages
5,836,484
Members
430,435
Latest member
Benforest1

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top