Correction in the IF and VLOOKUP Formula Required
Hi all,
can anyone help me with the below formula please
CellE5=MATCH(C4,Projecthours,0)*IF(ISNA(MATCH(C5,K:K,0)),"",VLOOKUP(C5,K4:N7,2,FALSE))
Can please check the file attached which has the information about my query
Thanks!
Santhoshi
Last edited by santhoshie; 08-02-2011 at 11:32 AM.
you're using the 2D version of INDEX, you need to move to the 3D version:
=INDEX($L$4:$N$7, MATCH(C5,ActivityList, 0), MATCH(C4, Projecthours, 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!)
Thanks a lot
it works now!!!!!!!
Hi,
It is similar to the earlier formula but in reverse case can you please help me out with this.
I want a formula in Cell K12 which matches the column J12:J15 list with cells from C4:C8 and matches cell K11 with C4:C8
can anyone please correct this formula mentioned in the excel sheet attached.
please read the comments in the file.
And also conditional formatting for the first table in the sheet please read the comments
Thanks
Santhoshi
Question 1 is unclear.
Question 2 is unclear.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
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 I have attached the file with comments in it can you please check the file and probably you can help me out in this as well.
Thanks
Santhoshi.
Last edited by santhoshie; 08-19-2011 at 05:07 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks