Member Avatar for PDB1982
PDB1982 0 Posting Whiz in Training

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)))
Edited by Reverend Jim because: wrong forum
  • 1 Contributor
  • 0 Replies
  • 99 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.