vLookup but choose either of 2 columns
Hi All,
I have a scenario where I want to lookup a value in column A but would like
to choose either column 4 or 5 from the resultant row in a drop down based on
other criteria I know. Is something like that possible? If so is it possible
to have a heading on each column to better identify which is which?
How would I attempt such a manouver?
Cheers
Hugh
|