Forum Discussion
Sotiris Moschou
Dec 14, 2017Copper Contributor
TRUE vlookup brings the wrong results
Hello to all,
I wanted to make my full-of-vlookups workbook faster so I thought I would start using vlookups(TRUE) on a sorted table since I read that its faster that way.
Problem is that...
JoB_19
Jan 07, 2019Copper Contributor
Updating by taking out the space before the *.
=VLOOKUP(A2&"*",costing!$A:$B,2,FALSE)
Let me know if this helps with your VLOOKUP.
Gaynor2022
Nov 23, 2022Copper Contributor
thank you for this but am lost @costing. FALSE vlookup is giving me wrong results even though the values are there on the table.