Hi,

Trying to combine a worksheet with rows of data with a "formal"
Excel report (separate sheet).


The data work sheet looks like

A B C D
Lab ID temp Pressure colour
1 .05 .09 Red
2 .06 .07 Blue
100-200 more rows etc.

The report looks like


LabID: 1

Temp: .05

Press .09

Colur Red

(the readings are always in the same cell).


The functionality needed is

Allow customer chooses a lab_id (using a form?)
The cells of the report are populated with the values for that labID.
The customer prints the report or specifies another labID

I was advised VLOOKUP could do this but don't really see how.
Hoping to avoid VBA if possible.

All help greatly appreciated.

Michael