NVRensburg
Board Regular
- Joined
- Jul 1, 2014
- Messages
- 100
- Office Version
- 365
- 2016
- Platform
- Windows
Please could I get some help. I'm using a VLOOKUP formula that uses the LOOKUP-VALUE which is a number from a result from another formula in that cell. It gives a result as NA, but if I type the number "1" in there, then it works.
The VLOOKUP formula is =VLOOKUP(L1,Sheet1!A:B,2,FALSE)
L1 formula contents is =MID(@CELL("filename",A1),FIND("]",@CELL("filename",A1))+1,255) which returns the value "1"
Please could someone assist as to how I can use the VLOOKUP formula that will work?
The VLOOKUP formula is =VLOOKUP(L1,Sheet1!A:B,2,FALSE)
L1 formula contents is =MID(@CELL("filename",A1),FIND("]",@CELL("filename",A1))+1,255) which returns the value "1"
Please could someone assist as to how I can use the VLOOKUP formula that will work?