Function VLookup but need Index-Match
Hello Guys
Newbie query
I need to know how to get D2 to look at C2 pick the number then refer to L, M and apply the correct formula
Like in image A2 the Panasonic DMP-BDT230EB attracts a VAT of 2 in C2 so D2 need to look L2 and M2 and work out the 20% value.
https://dl.dropboxusercontent.com/u/...20Function.png
Hope it makes sense
Thorrrr
Last edited by thorrrr; 10-30-2013 at 04:00 PM.
Hi Thorrrr,
Dead easy to provide an answer for, but unfortunately your thread title doesn't comply with forum rule #1.
If you can change it to something more descriptive of the issue then I'll be able to provide you with the solution to your query.
BSB.
I think that this is what you are after:
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Error reply please ignore
Last edited by thorrrr; 10-30-2013 at 04:02 PM.
Hi newdoverman
That looks great but i wanted the D column to show the value in money not copy over M column values.
Sorry might have been my poor explanation so in D2 it should say £16.99 then the E column add B2 and D2 to get full price.
I need to show VAT amount after it works out which one to apply.
Is this more what you had in mind?
Hi got an issues with L4 1 M4 0% in my main data its returning #N/A it should return £0.00 !!
It i breaking all the other calculations on the sheet
Last edited by thorrrr; 10-30-2013 at 05:57 PM.
Difficult to diagnose without seeing the problematic data in question...
You don't say where the error is but this should help.
The error means that a value is not available. Is the formula correctly getting the values from $L$1:$M$4? The only way that I can reproduce the error is to delete the 1 from that range.
INDEX-MatchError.xlsxStill breaking see here copy of sheet
The error values are cause by numbers in column D that are stored as TEXT. Click on the value in Column D and click on the yellow diamond and Convert to Number.
Last edited by newdoverman; 10-30-2013 at 06:44 PM.
Hi Newdoverman
Done as you said posted the sheet back to the link i gave made no difference !!!!
Ok i have done it cheers for all you patience and help
https://dl.dropboxusercontent.com/u/...atchError.xlsxThey are all displaying correct values but all cells in E column have an error
Last edited by thorrrr; 10-30-2013 at 06:52 PM.
Just ignore the error. The results are correct. To get an explanation of the error, click on one of the cells in column E then click on the diamond and click on Help on this error.
All sorted with a weird workaround but thank you to everybody great site with fast help
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks