This may help, if it is only few variables as given in the sheet.
=IF($B$4=1,E10,IF($B$4=2,F10,IF($B$4=3,G10,IF($B$4=4,H10,I10)))) and then drag (copy) the cells in the column.
The function "INDIRECT" combined with IF function can also help.
This may help, if it is only few variables as given in the sheet.
=IF($B$4=1,E10,IF($B$4=2,F10,IF($B$4=3,G10,IF($B$4=4,H10,I10)))) and then drag (copy) the cells in the column.
The function "INDIRECT" combined with IF function can also help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks