Forum Discussion
VLOOKUP problem
Hello, I have a problem with VLOOKUP formula. I want to use it to transfer the data from one table to another for specific data. When I use formula some of my cells give me proper data, but some of them give me wrong data. It happens only for positions 'Economist' and 'Financial analyst'. This cells get answer for 'Accountant" cells, rest work properly. The formula (wyszukaj.pionowo) = VLOOKUP. I'm using 365 office online, but the same problem occurs for excel 2007.
I'd recommend to use Exact match mode for VLOOKUP (4th parameter is FALSE) instead of default approximate match. Plus be sure you have no extra spaces in positions names.
3 Replies
I'd recommend to use Exact match mode for VLOOKUP (4th parameter is FALSE) instead of default approximate match. Plus be sure you have no extra spaces in positions names.
SergeiBaklan Ok, that helps, thank you very much for quick response.
syntrax , you are welcome, glad to help
