Search results

Ok, i got it... XLOOKUP is only for Office 365 and MS Excel 2019...

Sir still it is giving same result #Value!

Facing a problem with XLOOKUP:- I'm trying to use this formula for XLOOKUP :- but it's generating some kind of error #value! As highlighted (red color box) in the above image instead of giving NOT FOUND message, So what to do now❓ Formula used to perform this:- For more details kindly refer...

I'm trying to find out the Emp Id using it's name as explained at :- https://www.exceldemy.com/types-of-lookup-in-excel/, but it is generating some wrong values... I'm using MS Office 2007 for this... For Ex -: As shown in the table above the Emp Id for Kevin is 303 and 423 for James, but...