V look up

Hello Herve,
I hope you enjoyed your Excel training session with us.

In response to your question, you can use the vlookup function with numbers or text. False and true refer to the type of match you are looking for. "False" refers to an exact match, and "true" refers to a near match. When using "true" with numbers, you will get a result that is closest to the number you are searching for without going over. In this case, it is important that you first sort your data A>Z to ensure you are getting the closest match. When using it with text, it will search for the beginning of the string (for example, "Jennifer" will match on "Jen").

I hope this resolves your question. If it has, please mark this question as resolved. If you require further assistance, please reply to this post. And please feel free to ask any other questions you may have.

Have a great day.

Regards,
Mara
Microsoft Office Specialist Master Trainer