[vally]

I have a problem with looking up information in an excell table.

I have a table. In one collumn there is a serieal number list. in the other ones are data about this product.
This table was coppied from an access table (if this can affect any thing).
I wrote a vlookup table =VLOOKUP(A3,Wheare house!E:F,2,FALSE)
when some values are ok amd others i get #N\A
If any one knows what how to help or a different answer Id be happy

[Advertisements]

Perhaps the value being looked up in "Wheare house!E:F" doesn't exist?

[Vino Rosso]

Perhaps the value being looked up in "Wheare house!E:F" doesn't exist?

[vally]

It is in the same file.
I have done this before.


Here is how I used it before with some help from some one here and some personal changes but now I can't get it to work correctly.

=IF(ISNA(VLOOKUP(B63,'חשבונית 2'!F:H,2,FALSE)),"----", (VLOOKUP(B63,'חשבונית 2'!F:H,2,FALSE)))

all I get now is --- when I moved it to the table that I want (with changes).
I tried to play around so I would get the information in file I'm using now, but i get one type correctly and the rest of the information I get N/A

[Vino Rosso]

Just tried that formula and it works OK for me

Is the value being looked up in column F of the worksheet 'חשבונית 2'?

Is the value you want returned in column G of the worksheet 'חשבונית 2'?

[vally]

The answer to both questions is yes.

I don't understand why it does not work.
Like I posted I have used it before but it is not working
The only thing that is different is the data was transfered from an access table. It should not mean anything but ...

Any other ideas?

[Vino Rosso]

If you have been transferring data, make sure the value being looked up is in the same format as the data in the table.

For example, if you are looking up a serial number, say 12345, which is a number in the VLOOKUP formula BUT the 12345 is formatted as text in the table, the formula will return a false. That is, the lookup will not find the 12345.

[Jonesey]

If you have been transferring data, make sure the value being looked up is in the same format as the data in the table.

For example, if you are looking up a serial number, say 12345, which is a number in the VLOOKUP formula BUT the 12345 is formatted as text in the table, the formula will return a false. That is, the lookup will not find the 12345.

Yeah - I've come across this before when copying data out of Access into Excel - what looks like a number is in fact text.

Solution:
Insert a column next to your lookup values, then enter in the formula =Value(A1) (assuming the list starts in A1)
Now copy this all the way down.

Next - copy this list of results and paste VALUES into column A
Finally, delete column B

If this is the problem, the lookup will now work.

[vally]

Thanx Jonesey

It worked like a charm!!!

[Jonesey]

Wahey!!

Glad it worked for you.