Currently Being ModeratedNov 4, 2013 3:37 PM (in response to papalapapp)
Currently Being ModeratedNov 4, 2013 3:40 PM (in response to papalapapp)
Is this what you want?
It tries to look up the value in B from the table containing the ID's and if it can't find that value (gets an error) it puts a blank in the cell. If it does find the value in the list of IDs, it multiplies C x D.
I wasn't sure if that is exactly what you want because in your example there is no AAA in your list of IDs yet you still show a value in E.
SG, basically yes but if it can't find that value, it should only display the value from column C. If it finds it, multiply C with D.
I guess it works the same way as Wayne's formula but using VLOOKUP instead of MATCH.
Big thanks to both of you.
Currently Being ModeratedNov 4, 2013 5:18 PM (in response to papalapapp)
Yes, looks like basically the same idea, except that Wayne was faster and saw what you meant exactly.
Where my formula has the "" you would substitute C2, I think, to get the same result.
Thanks for the interesting problem. Keeps the mind sharp.