I think it can be but I am struggling.
In the example below, I want to use the $400 in the 'formula' spots. I know the first column doesn't match but need to lookup the $400 based on the 2nd and 3rd columns matching.
dog five car $400
cat five bus 'formula'
pig five car 'formula'
bird five car 'formula'
thanks
In the example below, I want to use the $400 in the 'formula' spots. I know the first column doesn't match but need to lookup the $400 based on the 2nd and 3rd columns matching.
dog five car $400
cat five bus 'formula'
pig five car 'formula'
bird five car 'formula'
thanks