Forum Discussion
Find corresponding value based on two columns
Hi experts How would you find the value in column c table a... when value in column A Table A has to be Total ABC and column b tables A has to be ABC..Find the result of this.
Anonymous I hope you are looking for something like this...
LOOKUPVALUE(TableA[ColumnC],TableA[ColumnA],"ABC",TableA[ColumnB],"ABC")
Hi The lookupvalue does not like the "ABC" part of the formula...
sorted thanks