Vlook up is not providing the correct answer

Dene Marcello

I am using VlookUP to bring the % complete amount from my Banya Project Management Sheet into my Banyaterza Sister Project Plan work sheet. The formula is working for two of the cells which I have highlighted in yellow, but for other cells it is giving the wrong response? The formula used on the Banyatereza Sister Project Plan is =VLOOKUP([Task Name]@row, {Banya Project Management Range 1}, 8)

I can not figure out why it is working sometimes and not others. Thank you for your help!

Screen Shot 2021-08-12 at 10.18.44 AM.png

Screen Shot 2021-08-12 at 10.18.44 AM.png

Paul Newcome

If you do not include that last portion in the VLOOKUP it defaults to "true" which is an approximate match. to get an exact match, use the last portion of the function and set it as "false".

=VLOOKUP([Task Name]@row, {Banya Project Management Range 1}, 8, false)

Paul Newcome

If you do not include that last portion in the VLOOKUP it defaults to "true" which is an approximate match. to get an exact match, use the last portion of the function and set it as "false".

=VLOOKUP([Task Name]@row, {Banya Project Management Range 1}, 8, false)

Dene Marcello

Thank you so much, it works perfect!

Paul Newcome

Happy to help. 👍️