Daizy has attended:
Excel Advanced course
PowerPoint Intermediate Advanced course
Word Advanced course
Excel XLOOKUP returning #VALUE and can't work out error
=XLOOKUP([@[Project ID]],Table4,Table4[Project Postcode],"N/A",0,1)
I am trying to use this formula to search the Project ID reference within Table4 (on a different sheet) and to return the Project Postcode that corresponds with the Project Number. It keeps returning #VALUE and not sure which part is wrong?