Jul 01 2022 05:28 AM
The below formula works in some cells and returns #N/A in others.
=IF(F2>0,VLOOKUP($A2&F2,DrayConsolidation!$A:$E,5,FALSE),"")
when I do the trace it shows refrecing to the other sheet in the book but I can't see where it's
Jul 01 2022 05:58 AM
Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.
Jul 01 2022 06:12 AM
Jul 01 2022 06:57 AM
Perhaps a new screenshot, with ALL relevant columns included, and also a screenshot of the other sheet, with all relevant columns. You can blank out or change data that you'd rather not show.
Jul 01 2022 07:30 AM
sheet with bad formula
sheet the vlookup goes to
second half of sheet vlookup goes to
Jul 01 2022 08:20 AM
I'm really sorry, but I can't do anything with that...