value

[kenpcli]

How do I get the formula to return just the value into the cell:

=IFERROR(VLOOKUP(C2,'08-05 TO 08-11'!$C:$Q,4,0),"")

I don't need the formula left in the cell just the value it finds

Thank You

 

[Yongle]

If you want to replace the formula in the cell with the value

right-click on the cell and click on COPY
right-click on the cell again and (under PASTE options) click on PASTE VALUES (the icon has 123 at the bottom)

This makes the value permanent

 

[fhqwgads]

right-click PASTE VALUES

for the keyboard shortcuts, after you use Ctrl+C to copy the cell, you can use Alt+E, then S, then V and then Enter for paste values only. not sure if it still works in newer versions of excel though

 

[Yongle]

for the keyboard shortcuts, after you use Ctrl+C to copy the cell, you can use Alt+E, then S, then V and then Enter for paste values only. not sure if it still works in newer versions of excel though

It does still work