vlookup not working

game001

New Member
Joined
Mar 26, 2019
Messages
11
Hi,


The top table is my excel sheet named Vlookup.

As you can see the value I am trying to get is on the 13th row. It is still returning N/A.

Please help.

Thanks



 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,831
Office Version
  1. 365
Platform
  1. Windows
It appears the product codes on the 2nd sheet are numbers stored as text.

Try changing your VLOOKUP formula to this.

=VLOOKUP(B8+0,VLookup!$A$3:$C$27,3,FALSE)
 

game001

New Member
Joined
Mar 26, 2019
Messages
11
It appears the product codes on the 2nd sheet are numbers stored as text.

Try changing your VLOOKUP formula to this.

=VLOOKUP(B8+0,VLookup!$A$3:$C$27,3,FALSE)

Genius you people are.

Thanks a mil
 

Watch MrExcel Video

Forum statistics

Threads
1,109,227
Messages
5,527,532
Members
409,769
Latest member
Hudz

This Week's Hot Topics

Top