I was wondering if anyone can tell me what is wrong with this code in EXCEL. I'm trying to fill in one cell (in this case, K2), based on the wording in an adjacent cell (in this case, J2). If J2 does not state "PENDING", then I want to reference a date from a cell in the previous sheet based on an ID number that acts as a primary key on all sheets: =IF(J2="PENDING", "PENDING",(VLOOKUP($A2:A882,'[Sheet3]CASE MAIL DATES'!A:V,7,0)))

Member Avatar
+0 forum 0

Dear all, Im getting a problem in Excel. Vlookup formula is working correct. Now the problem is when more than one time asc-1 comes in posting column, it do not show the 2nd name with asc-1. Formula for the vlookup is : =VLOOKUP(N15,A11:G87,2,FALSE) What will be the solution and how? Replyies will be appreciated.

Member Avatar
Member Avatar
+0 forum 1

Problem: I have a version of 2003 of MS EXCEL for example I have Line A and Line B in the same work sheet the DATA of Line A has a b c d e and f the data of Line B has b and d only if I use this formula Vlookup($A:$A,$B:$B,1,FALSE), it returns b and d in line C but what I want is th the a c e and f how would I do that. in discerete Mathematics, vlookup() is the INTERSECTION of 2 sets but what I want is NOT the INTERSECTION of two sets in …

Member Avatar
Member Avatar
+0 forum 2

I dont know where to post it, but this is the reliable help from geeks I've known for several years Problem: I have a version of 2003 of MS EXCEL for example I have Line A and Line B in the same work sheet the DATA of Line A has a b c d e and f the data of Line B has b and d only if I use this formula Vlookup($A:$A,$B:$B,1,FALSE), it returns b and d in line C but what I want is th the a c e and f how would I do that. in discerete …

Member Avatar
Member Avatar
+0 forum 1

The End.