vlookup help

[jdunaj]

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.

Please help- thank you!</SPAN>

 

[VoG]

This may help Excel VLookup Function Examples

Does E175 contain a formula? If so, what is it?

 

[jdunaj]

It does not. E175 is the invoice#

 

[jdunaj]

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

thank you!!

 

[Jonmo1]

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)