golfnut019
Board Regular
- Joined
- Nov 11, 2005
- Messages
- 58
=IF(ISBLANK(P6574),VLOOKUP(G6574,'HC-CID'!A$2:I$65185,8,FALSE),IF(Q6574>37809,VLOOKUP(G6574,'HC-LID2'!A$2:I$65185,8,FALSE),VLOOKUP(G6574,'HC-LID'!A$2:I$65185,8,FALSE)))
Here's what's going on :
the isblank part is pretty self-explanatory.
I want the formula to check the data, and if it's greater than 12/23/2005, it'll look for the G value in the HC-LID2 sheet and if it's less than or equal 12/23/2005, it'll go to the HC-LID sheet.
I keep getting a #N/A for dates less than or equal to 12/23/2005 although when i manually look up the G value in the HC-LID sheet it's there.
Is there anything fundamentally wrong with the formula?
Thanks
Here's what's going on :
the isblank part is pretty self-explanatory.
I want the formula to check the data, and if it's greater than 12/23/2005, it'll look for the G value in the HC-LID2 sheet and if it's less than or equal 12/23/2005, it'll go to the HC-LID sheet.
I keep getting a #N/A for dates less than or equal to 12/23/2005 although when i manually look up the G value in the HC-LID sheet it's there.
Is there anything fundamentally wrong with the formula?
Thanks