J Joshuavdh Joined May 29, 2017 Messages 2 Reaction score 0 May 29, 2017 #1 Hi I want to use the result of my vlookup in another formula. The =--vlookup(...) does not work and gives me #value! I am using excel 2013 and I merely want to multiply the vlookup cell/result with another cell
Hi I want to use the result of my vlookup in another formula. The =--vlookup(...) does not work and gives me #value! I am using excel 2013 and I merely want to multiply the vlookup cell/result with another cell
Becky Webmistress Joined Mar 25, 2003 Messages 7,424 Reaction score 1,511 May 29, 2017 #2 It sounds like you have a problem with your VLOOKUP. Does it work OK in isolation? (ie before you try to multiply the result)
It sounds like you have a problem with your VLOOKUP. Does it work OK in isolation? (ie before you try to multiply the result)
Becky Webmistress Joined Mar 25, 2003 Messages 7,424 Reaction score 1,511 May 29, 2017 #3 This guide might help you troubleshoot it: How to correct a #VALUE! error in the VLOOKUP function
