Pestomania
Active Member
- Joined
- May 30, 2018
- Messages
- 330
- Office Version
- 365
- Platform
- Windows
I feel like I should know this but am drawing a blank. I have a table of 3 columns and 10 rows and two values to locate.
In column 1, I want to find the number 29850 and I want to locate in column 2 the term "report" and return the value in column 10.
So an idea is as below:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Sequence[/TD]
[TD]Type[/TD]
[TD]Order[/TD]
[/TR]
[TR]
[TD]29960[/TD]
[TD]Report[/TD]
[TD]Complete[/TD]
[/TR]
[TR]
[TD]10099[/TD]
[TD]Test[/TD]
[TD]Incomplete[/TD]
[/TR]
[TR]
[TD]19045[/TD]
[TD]Report[/TD]
[TD]Half-Complete[/TD]
[/TR]
[TR]
[TD]29850[/TD]
[TD]Report[/TD]
[TD]Complete[/TD]
[/TR]
[TR]
[TD]29850[/TD]
[TD]Test[/TD]
[TD]Incomplete[/TD]
[/TR]
</tbody>[/TABLE]
So using this, It would locate in the first column "29850" and find the term "report" in column 2, and return the phrase "complete"
In column 1, I want to find the number 29850 and I want to locate in column 2 the term "report" and return the value in column 10.
So an idea is as below:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Sequence[/TD]
[TD]Type[/TD]
[TD]Order[/TD]
[/TR]
[TR]
[TD]29960[/TD]
[TD]Report[/TD]
[TD]Complete[/TD]
[/TR]
[TR]
[TD]10099[/TD]
[TD]Test[/TD]
[TD]Incomplete[/TD]
[/TR]
[TR]
[TD]19045[/TD]
[TD]Report[/TD]
[TD]Half-Complete[/TD]
[/TR]
[TR]
[TD]29850[/TD]
[TD]Report[/TD]
[TD]Complete[/TD]
[/TR]
[TR]
[TD]29850[/TD]
[TD]Test[/TD]
[TD]Incomplete[/TD]
[/TR]
</tbody>[/TABLE]
So using this, It would locate in the first column "29850" and find the term "report" in column 2, and return the phrase "complete"