Im sorry for i am not an native english speaker and i am a newbe at this, so i’ll try to explain as clearly as i can.
I would like a cell to produce a value based on a cell range from a table column A (by validity, cell range ect.)
Hovewer i would like for a next cell to show corresponding value from column B of the same table.
is there a fomula for such thing?
(I do know that simple multi use of If function would do the trick, but i got loads of rows in this table and doing it by hand just kills me.)
