Vlookup Help Simple answer

Novina

New Member
Joined
Sep 24, 2007
Messages
13
Can someone please help me?

I'm doing a vlookup but it keeps coming up #n/a, but i know the information is on the other tab. I don't understand why it isn't picking it up.

Can someone send me a message, I can not attach the sheet here. But i can send the file for some help.

I really need to get this done, anything would be appreciated!
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
Novina, we need more info than that I'm afraid - for ex what is the value you think should exist, what is the formula you are using, where is the data you're trying to find.
 
Upvote 0
Maybe you have text in one and numbers in the other? Or, maybe there are trailing spaces?

=VLOOKUP(A1+0,table,column,0) will correct the issue if A1 is text and your table is numbers

=VLOOKUP(A1&"",table,column,0) will correct the issue if A1 is a number and your table is text

=VLOOKUP(A1,TRIM(D1:E3),2,0) will correct for trailing 0's if you're trying to return text (note that this is an array formula and must be confirmed with CTRL+SHIFT+ENTER (doing so correctly will result in Excel putting {}'s around your formula in the formula bar))

And the adjustment =VLOOKUP(A1,TRIM(D1:E3),2,0)+0 still confirmed with CTRL+SHIFT+ENTER will return a number instead of a text value if you're expecting a number...
 
Upvote 0
using this =vlookup(A1288,komatsu!A1:B5,2,false)

The value that should show up the 8.
 
Upvote 0
following Oaktree, 99.9% of the time this is down to incompatible types between criteria and lookup range.

if A1278 is a number do the following

=ISNUMBER(A1288)

then do

=ISNUMBER(komatsu!A1)

what do you get for each ?
 
Upvote 0
If komatsu!A4 is supposed to match A1288, put =A1288=komatsu!A4 in a cell.

Select the A1288 part in the formula bar and press F9, then select the komatsu!A4 part in the formula bar and press F9.

The two text strings have to be different... maybe it's punctuation or extra spaces or something else...
 
Upvote 0
could you please list what is in A1278 and also contents of A1,A2,A3,A4,A5 ?

EDIT: see Oaktree's suggestion first, if not resolved pls do the above.
 
Upvote 0
This is tab 1
Catalog No Generic Part No Price Sheet Description NEW CAN ON HWY MRP Ctn Qty Ctn Weight EHC ABC Class
AF0033500 M AF335M AIR FILTER 46.53 1 5.95 0 B


Komatsu tab
Part Number Qty
391824300 S 1
394445100 S 2
394670500 S 3
AF0033500 M 8
AF0033600 M 8
 
Upvote 0

Forum statistics

Threads
1,213,513
Messages
6,114,064
Members
448,545
Latest member
kj9

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