Question about Microsoft Excel for PC
I'm try to use vlookup formula and doesn't found the value.
The formula is as follow:
=VLOOKUP(CONCATENATE(D3,L3),'[bills up to 022908.xls]Sheet1'!$G$3:$J$50000,4,0)
D3= file number
the index column is another concatenate(file number,amount)
Suggest you do some debugging in steps:
1. Open the 'bills up to 022908.xls'
2. Use an empty cell to "=CONCATENATE(D3,L3)". That way you can see what values are being generated.
3. Copy the values of that cell and see if you can find them in Col G of 'bills up to 022908.xls'.
Once its broken down into pieces you can usually see "the error of your ways."
Hope this helps.
Posted on Mar 10, 2008
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
Here's a link to this great service
Posted on Jan 02, 2017
Tips for a great answer:
Jul 14, 2017 | The Computers & Internet
Feb 18, 2009 | Microsoft Computers & Internet
Feb 11, 2009 | Microsoft Excel for PC
Jul 12, 2008 | Excel (SS8SATAS5128400R)
Feb 03, 2008 | Microsoft Excel for PC
Jan 07, 2008 | Computers & Internet
Aug 30, 2007 | Microsoft Office Standard for PC
Aug 27, 2007 | Microsoft Office Standard for PC
Jan 28, 2016 | Microsoft Excel for PC
Dec 12, 2013 | Microsoft Excel for PC
Jul 23, 2013 | Microsoft Excel for PC
110 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: