Vlookup

[VbaHell]

Hello all
I would like to know if there is some VBA code that can remove zero's from a column. I am trying to code a vlookup against two spreadsheets but the one sheet has zero's and the other does not. below is an example on the difference but I need to keep any zero's after the first number if that makes sense ie 32304 need to keep this zero


00004567 4567
00032304 32304
00234340 234340
01234398 1234398

 

[Jonmo1]

Given this dummy vlookup formula...

=VLOOKUP(Sheet1!A1,Sheet2!D:E,2,FALSE)

Which part has the leading 0's? Red or Blue?

 

[VbaHell]

I should have been clearer in my question.

Sheet1 A1 has 00004567 and sheet2 A1 has 4567
The Vlookup would be from sheet2 selecting 4567 then matching up with sheet1 00004567 and droping the answer into sheet2 column B1

 

[Jonmo1]

Try

=VLOOKUP(TEXT(Sheet2!A1,"00000000"),Sheet1!A:B,2,FALSE)

 

[VbaHell]

Hi I am still having a problem


Tab1

Cell A1 Cell B1
00004342


Tab2
Cell A1 Cell B1
4342 21/8/11

I need to vlookup Tab1 Cell A1 against Tab2 Cell A1 and drop Cell B1 back into Tab1 Cell B1

Sorry to be a pain but the answer coming back is n/a and I think it's because of the 0000 in Tab 1

 

[Jonmo1]

OK, it was the other way around

Try

=VLOOKUP('Tab 1'!A1+0,'Tab 2'!A:B,2,FALSE)