Hi,
Wondering if anyone could help me out with this query – I’ve done some googling but can’t find the answer so not sure if I’m just not searching the right terms or something.
I’ve got some data in the format:
...........Eggs......Bacon
Ref 1......10.........16.3
Each row is an observation, with Ref1 being the reference number for the observation
The allowable values for factor Eggs and factor Bacon are contained within a reference table in the format:
Eggs............................Bacon
10.....0.0003...............14.....0.0003
11.....0.0004...............15.....0.00061
12.....0.0003...............16.....0.001
13.....0.00075.............16.1...0.00075
14.....0.0003...............16.2...0.0001
15.....0.00061.............16.3...0.0004
16.....0.001 ...............16.4...0.0009
I’d like to insert a formula such that on a separate worksheet there is an output in the format:
.......................Eggs..........Bacon
Ref 1...............0.0003.......0.0004
i.e. excel will look at the value ‘10’ held in the Eggs column and return the value ‘0.0003’ based on the reference table
This seems like a fundamental thing to be able to do, but I can’t work it out, so any help greatly appreciated!
Thanks,
EpsilonX
Bookmarks