William C Johnson
asked on
Excel 2010 VLOOKUP
Can someone tell me how to format a VLOOKUP to provide the following text in the cell when the vlookup fails to find the requested data? I want to replace the #N/A with NO TITLE FOUND - COPY TITLE FROM CAST. See sample file attached.
Thanks,
Bill
Test1.xlsx
Thanks,
Bill
Test1.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Both solutions work great. Thank you.
ASKER
Solution worked as expected. Thank you.
This is a great way to spruce up your spreadsheet so that you don't see traditional Excel errors.
=IF(ISNA(VLOOKUP(A2,Sheet2
Just drag this formula down through the other columns.
Tested and works lovely.