Hello All,
I am looking for a formula which will have multiple criteria for vlook.
Its just that if Employee Id match than please look for E2 and give column 3
Please check for attach file for better picture.
Thank You
Hello All,
I am looking for a formula which will have multiple criteria for vlook.
Its just that if Employee Id match than please look for E2 and give column 3
Please check for attach file for better picture.
Thank You
Last edited by crescendo; 02-26-2015 at 07:14 PM. Reason: optional
Please help. I really need some kind solution for this. Please
hi
Sorry Wrong solution Provided
Punnam
Last edited by Punnam; 02-27-2015 at 12:17 AM.
Hey punnam,
Thanks for helping me but its not doing its job. Nothing is coming up in F2 or G2, Please help
Hi crescendo,
This is one of those Array Formula or Control+Shift+Enter types.
You also MUST spell 3 Days, 6 Days, 9 Days, 11Days and 15Days EXACTLY the same on both sheets. That was a real problem here.
http://spreadsheets.about.com/od/exc...s-tutorial.htm
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Thanks Man, I really appreciate it.
I was trying to do as Vlookup but i really appreciate it thanks a lot.
Hey is there any way that wen can put if error formula in this??
Many are coming up as #NA. Please help you are really good man.
Put this in F2 and enter with a CSE.
=IFERROR(INDEX(Coach!$E$1:$E$9,MATCH($A2&F$1,Coach!$A$1:$A$9&Coach!$D$1:$D$9,0)),"")
Then pull it down and to the right.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks