i have two colums , a & b , each are data validated to give various options
these options have been taken from another sheet within workbook (columns a & b)
column c holds the information that needs to be returned when any of the options are selected via the data validation.
here is how the info is set up on the first sheet
Column A Column B Column C
1.8 1.8 £100
2.4 2.4 £200
1.8 2.4 £300
on my second sheet colums a & b are data validated for various selections. i cant get the lookup to return the answer from column c when both columns a&b are selected.
any takers?
Bookmarks