Hi I have included a file to accompany this thread. On the sheet teamdata in J3 the formula works fine and returns mia from th database sheet. My question is why the same formulas do not work in L3 N3 P3 and J4. I am sure my vlookups will work once the other cells get fixed. So kind of lost to why they won't work any help would be appreciated. Thanks in advance Andy.
Last edited by adsxvii; 11-25-2007 at 12:32 PM.
Don't see any attachment, Andy.....
dont know where it wentI uploaded it though should be there :P
Try this formula in J3 and similar in the other cells
=INDEX(Database!$C$2:$C$20000,MATCH(1,(Database!$A$2:$A$20000=$A3)*(Database!$B$2:$B$20000=J$2),0))
confirmed with CTRL+SHIFT+ENTER
ty as always daddy, just wondering why it might be that the other way I had it didn't work?. Anyhow problem solved thanks again.
actually 1 more small problem is the vlookups next to them in k3 m3 o3 etc. The first one works in k3 but not the rest. Any reasons why 1 would work and not the other?
Usually, unless you are looking for a "closest match" in a sorted lookup range, which you aren't here, your VLOOKUP needs a 4th argument of 0 or FALSE, i.e.
=VLOOKUP(L3,$A$3:$I$23,9,0)
Thanks again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks