I want to do a look up on the values :
1) in column B and column E based on the values in column A and column D.
For example, if I enter a value in col A such as the id in the attached, then the name will appear in col B and I enter
the secid in col C, then the holding will appear in col D.
2) look up the values in col B and col D based on the value in col C. For example, the value of Secid is enter and the
result would be show in col B and col D.
What is the formula to use for this. Can I use Vlookup in this?
Attached a dummy sample.