anewday777

New Member
Joined
Jan 23, 2017
Messages
9
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

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
can you give us a sample of what is in B2 as well as the Range?
 
Upvote 0
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>
 
Upvote 0
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>
 
Upvote 0
both sheets show tid, i was using tid and looking at other sheet to find the tid and return the install date
 
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0
I'd check specifically that data. the only thing that makes sense is that there's an extra/different character in the string.
 
Upvote 0

Forum statistics

Threads
1,217,433
Messages
6,136,596
Members
450,021
Latest member
Jlopez0320

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
Back
Top