# vlookup help

#### jdunaj

##### New Member
Hello, I am in need of your help using the vlookup function. I use this function all the time, however on this specific report I cannot get a result. I am trying to find a specific cost associated with an invoice number. The formula I am using is =VLOOKUP(E175,A2:H145,8,FALSE) where E175 is the invoice number I am looking for in table A2:H145. I made sure that the first column in the table is the invoice# and it is in ascending order. Column 8 is the invoice amount that I need.

### 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.
It does not. E175 is the invoice#

Yes! your link helped!! I needed to change the formula to =VLOOKUP(TEXT(E175,"00000"),A2:H145,8,FALSE)

thank you!!

Sounds like either:
1. E175 is a Number but A2:A145 are "Numbers stored as text"
2. Vice Versa

What do these return
=ISNUMBER(E175)
=ISNUMBER(A2) - Filled down to A145

Perhaps you can use
=VLOOKUP(E175+0,A2:H145,8,FALSE)
or
=VLOOKUP(E175&"",A2:H145,8,FALSE)

Replies
3
Views
110
Replies
22
Views
693
Replies
6
Views
199
Replies
2
Views
214
Replies
5
Views
219

1,196,057
Messages
6,013,176
Members
441,751
Latest member
336448

### 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.

### Which adblocker are you using?

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

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