LinkBack URL
About LinkBacks
Hi All,
I want to learn VLOOKUP formula in this following problem.
HTML Code:
I am attaching the file for the same. Could plz suggest me where i am wrong in this formula. ?
Regards,
Upananda
Error in VLookup formula
Hi All,
I want to learn VLOOKUP formula in this following problem.
HTML Code:
I am attaching the file for the same. Could plz suggest me where i am wrong in this formula. ?
Regards,
Upananda
Last edited by pani_hcu; 08-30-2009 at 02:54 AM. Reason: Got the solution
Upananda
VLOOKUP won't work in that layout. VLOOKUP matches one instance of a sought value. You have 11 instances of each.
You need to use a basic INDEX/MATCH. Like we've used in the past. If you're willing to eliminate those empty cells in Sheet2 by putting in the company names all the way down, this will work in OutPut cell D3...copied down and then across:
=INDEX(Sheet2!C$3:C$112, MATCH(Output!$A3 & "-" & Output!$B3, INDEX(Sheet2!$A$3:$A$112 & "-" & Sheet2!$B$3:$B$112, 0), 0))
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Hi JB,
I am greatful to you for ur help. I know without ur help, I wouldn't have come so far.
With Sincere Regards,
Last edited by pani_hcu; 08-30-2009 at 03:33 AM. Reason: edit
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks