Hello once again.
I am having a problem with my VLOOKUP. I have a two colum chart A1 have a clients Number and A2 has the client Name.
On a second sheet I have formula where I enter the Client Number and the Name fills in.
=IF(ISNA(VLOOKUP(S10,Client,2,false))," ",VLOOKUP(S10,Client,2,false))
The chart is named "Client"
Everything works fine until I enter a client number greater than 1000.
Both columns are formated as text. So if I enter client number 0098 I get a correct response. If I enter 1101 I get no response. The numbers are in order and there are gaps in the numbers through out the chart.
If anyone could help
Thanks
David
I am having a problem with my VLOOKUP. I have a two colum chart A1 have a clients Number and A2 has the client Name.
On a second sheet I have formula where I enter the Client Number and the Name fills in.
=IF(ISNA(VLOOKUP(S10,Client,2,false))," ",VLOOKUP(S10,Client,2,false))
The chart is named "Client"
Everything works fine until I enter a client number greater than 1000.
Both columns are formated as text. So if I enter client number 0098 I get a correct response. If I enter 1101 I get no response. The numbers are in order and there are gaps in the numbers through out the chart.
If anyone could help
Thanks
David