Find a value in a table by matching two values

Vosy

New Member
Joined
Nov 2, 2005
Messages
2
Hi There, :-D
I'm trying to find a way of looking up a value by matching two other values. :-?

I'm not sure if I'm making sense but this is what I mean;
Just say for example I have a row of dates at the top and a column of company names at the side.
In the table there are values relating to the company on certain dates
How do I put a formula in elsewhere which will lookup the date and the company name and tell me what the value was for that date and company. :huh:

I'm sure it's an easy formula but after a day of looking at it I'm going a bit stir crazy here!!!! :banghead:

Hope you can help. :pray:

Many Thanks
Vosy :oops:
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
Thanks

Well thank you most kindly :beerchug:

You've saved me much heartache :hammer:

thank you thank you thank you :D
 
Upvote 0

Forum statistics

Threads
1,223,229
Messages
6,170,880
Members
452,363
Latest member
merico17

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