extracting info from an existing set of data

gmg

New Member
Joined
Aug 31, 2010
Messages
4
I am working a spreadsheet and would like it to take information that i input. Then compare it to a table on a seperate worksheet by comparing the top row of information and comparing it with the left hand side and then return where the information intersects.
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.
I think this is pointing me in the right direction but I am having a challenge creating communication between the sheets. I have a spreadsheet page one that in column A I would like to input a number, then in column B I would like to input another number.
These two numbers would then correlate with a chart on the next sheet that has a row across the top of reference numbers that correlate to the #s I will be putting into Column A and then a column on the left side that will correlate to the #s I will be inputing into column B. I need it to return the cross referenced # from the chart on sheet 2 then in column C
 
Upvote 0

Forum statistics

Threads
1,224,524
Messages
6,179,304
Members
452,904
Latest member
CodeMasterX

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top