98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Vlookup
Vlookup
Resolved · Medium Priority · Version 2007
Wed 3 Jun 2009, 16:27Delegate Brian said...
Brian has attended:
Excel Introduction course
Vlookup
I have work on one sheet with several tabs, the problem being when i did a vlookup from one tab to another tab it failed to find a part number that was on both tabs. Even when I formated the tabs to the same on both tabs it still didn't find it. And even when I re-typed the numbers in in the same format, font colour, it still didn't find it. Any help will be graetly appreciated and if need be the file can be sent for perusal.
Mon 8 Jun 2009, 12:01Trainer Anthony said...
RE: vlookup
Hi Brian, thanks for the query. Sometimes when the vlookup function doesn't work , the number in the cell is being treated as text. Try applying consistent number formatting to all your cells or use the =value() command in a new column and copy the numbers back, and then performing the VLOOKUP.
Hope this helps,
Anthony
Mon 15 Jun 2009: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Move to edge of data blockWhen data is held in a block, however large, use the Ctrl key with your cursors to move quickly to the far edge of the block. Works with all 4 direction keys. |
