I guess it depends how the data comes out of the database. If it's coming out as text, you can either use the apostrophe in B7, or instead type a number in, then use TEXT(B7,"00000") instead of B7 in the VLOOKUP ....
I guess it depends how the data comes out of the database. If it's coming out as text, you can either use the apostrophe in B7, or instead type a number in, then use TEXT(B7,"00000") instead of B7 in the VLOOKUP ....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks