Excel - COLUMN Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I have a three column data sheet I need to look up an age in the first column that will give me many rows with the first age then I need to lookup the age in the second column that matches my choice and produce the number that's in the third column
Solved by T. H. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 24/04/2018 - 02:29
Welcome !
User 24/04/2018 - 02:30
Are you there?
Excelchat Expert 24/04/2018 - 02:30
Yes I am
Excelchat Expert 24/04/2018 - 02:31
You have a question on multiple lookups and results processing-is that correct?
Excelchat Expert 24/04/2018 - 02:31
Do you have a sheet to share, so I can evaluate options?
Excelchat Expert 24/04/2018 - 02:32
User 24/04/2018 - 02:32
I have three columns of data. Thet are ages in both column one & two I need to lookup the first number in column one the corresponds to the age I have in column two and give me the value in column three
User 24/04/2018 - 02:34
How would I lookup row ine 71 and the corresponding value in column three if column two was 39
Excelchat Expert 24/04/2018 - 02:35
I need to look at this a bit.
User 24/04/2018 - 02:35
Can you see the numbers I entered in the Excel spreadsheet to my right?
Excelchat Expert 24/04/2018 - 02:35
User 24/04/2018 - 02:36
I know vlookup well but can't figure this out
Excelchat Expert 24/04/2018 - 02:36
You want to lookup column A , and find column B and C that match?
Excelchat Expert 24/04/2018 - 02:36
Can you give an example of the output?
Excelchat Expert 24/04/2018 - 02:36
I am not sure what Lookup problem you are having from this data?
User 24/04/2018 - 02:37
Yes the numbers in column one & two are ages and the number in colmn three need to match my two ages
User 24/04/2018 - 02:37
for example if I have ages 71 & 39 i need to get 0.58001
Excelchat Expert 24/04/2018 - 02:37
Match? col a and b are integers, col C is a fraction
User 24/04/2018 - 02:39
This table is over 7,000 rows
Excelchat Expert 24/04/2018 - 02:39
OK. So the combination of 71& 39 result in .53
User 24/04/2018 - 02:39
Excelchat Expert 24/04/2018 - 02:39
Oops need my glasses.
User 24/04/2018 - 02:40
got the sane problem
User 24/04/2018 - 02:40
Excelchat Expert 24/04/2018 - 02:40
I think the easiest way is to create an index of A&B and lookup C
User 24/04/2018 - 02:40
how does that work?????
Excelchat Expert 24/04/2018 - 02:41
Can I take this down to desktop, this viewer is a pain to work on real formulas, but Iwill review with you.
User 24/04/2018 - 02:42
I appreciate your help.
Excelchat Expert 24/04/2018 - 02:46
OK, take a look at this quick fix and let me know, if this helps
Excelchat Expert 24/04/2018 - 02:47
[Uploaded an Excel file]
User 24/04/2018 - 02:49
Bingo that's it. Thank you so much. Ron
User 24/04/2018 - 02:49
where are you physically?
Excelchat Expert 24/04/2018 - 02:50
I am in Southern Nevada, I am not allowed to give out too much PII , but i think that is OK
Excelchat Expert 24/04/2018 - 02:50
Anything else I can help with today?
User 24/04/2018 - 02:50
Thanks again I got to go. Will use your service again if needed.
Excelchat Expert 24/04/2018 - 02:51
Yes , please stop by anytime. thanks

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc