i need the formula of
in the sheet 1 if the cell f3 value is "zone1" than take the value of the cell of the sheet 2 a1 and if the cell f3 is" zone2" than take the value of the cell of the sheet 2 a2....
i need to add 5 zone respectivly
can you help me to get the right code
thank you
Bookmarks