Matching two columns of data

[EvansB2]

Hi there,

I would like to return a value in cell E3 below that equates to the value in cell B3 only when the 'Room' reference in Table 1 cell A3 matches same in Table 2 (cell D3). The first Table, which is Table 1, is the master table and runs for some 500 rows and has all the room numbers and Table 2 is some 75 rows. I think this is the problem I'm having as I don't know if the tables need to be an exact match? I would appreciate any assistance you can offer. I have tried using Html to present the relevant columns, however I have had trouble with it due to company security issues.

Regards

Ben


[TABLE="width: 300"]
<colgroup><col width="29" style="width: 22pt; mso-width-source: userset; mso-width-alt: 1060;"> <col width="82" style="width: 62pt; mso-width-source: userset; mso-width-alt: 2998;"> <col width="84" style="width: 63pt; mso-width-source: userset; mso-width-alt: 3072;"> <col width="48" style="width: 36pt; mso-width-source: userset; mso-width-alt: 1755;"> <col width="74" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2706;"> <col width="81" style="width: 61pt; mso-width-source: userset; mso-width-alt: 2962;"> <tbody>[TR]
[TD="class: xl77, width: 29, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl78, width: 82, bgcolor: #D9D9D9"]A[/TD]
[TD="class: xl78, width: 84, bgcolor: #D9D9D9"]B[/TD]
[TD="class: xl78, width: 48, bgcolor: #D9D9D9"]C[/TD]
[TD="class: xl78, width: 74, bgcolor: #D9D9D9"]D[/TD]
[TD="class: xl78, width: 81, bgcolor: #D9D9D9"]E[/TD]
[/TR]
[TR]
[TD="class: xl79, bgcolor: #D9D9D9"]1[/TD]
[TD="class: xl76, bgcolor: transparent"]TABLE 1[/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl76, bgcolor: transparent"]TABLE 2[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl79, bgcolor: #D9D9D9"]2[/TD]
[TD="class: xl71, width: 82, bgcolor: black"]Room Number
(Contractor Ref)[/TD]
[TD="class: xl72, width: 84, bgcolor: black"]Area as Accomodation Schedule rev B
m2[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl73, width: 74, bgcolor: #92D050"]Room[/TD]
[TD="class: xl73, width: 81, bgcolor: #92D050"]Room Area[/TD]
[/TR]
[TR]
[TD="class: xl79, bgcolor: #D9D9D9"]3[/TD]
[TD="class: xl66, bgcolor: transparent"]L-CS-1001[/TD]
[TD="class: xl67, bgcolor: transparent"]23[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl65, width: 74, bgcolor: transparent"]L-CS-1001[/TD]
[TD="class: xl74, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl79, bgcolor: #D9D9D9"]4[/TD]
[TD="class: xl68, bgcolor: transparent"]L-HQ-0067[/TD]
[TD="class: xl69, bgcolor: transparent"]18[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl65, width: 74, bgcolor: transparent"]L-CS-1002[/TD]
[TD="class: xl75, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl79, bgcolor: #D9D9D9"]5[/TD]
[TD="class: xl68, bgcolor: transparent"]L-HQ-0084[/TD]
[TD="class: xl69, bgcolor: transparent"]16[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl65, width: 74, bgcolor: transparent"]L-CS-1003[/TD]
[TD="class: xl75, bgcolor: transparent"] [/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

If you are just trying to match up on two columns of data, then return the value from a corresponding column, you should be able to use the VLOOKUP function.
See this for examples are explanations: https://www.techonthenet.com/excel/formulas/vlookup.php