So what is your search data, what does your table look like, where does it reside, what did you try that didn't work (BTW, what
does "didnt work" mean? Error? what error? wrong reply?) What did you get and what did you expect?

BTW, there is no V-lookup, there is VLOOKUP. Are you sure you know what you're trying to do?

Please post again in this same thread if you need AND have more information.

--
Kind regards,

Niek Otten

"Asma Shah" <u21773@uwe wrote in message news:601b624296874@uwe...
|I used V-lookup to use it on the other sheet....
| i want discount to get change when i change hours and Lesson type in my sheet.
| ...
| my teacher told me to use V-Lookup table but it didnt work so wot should i do.
| ...?