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
Hello?
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
Yes.
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
.58001
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
same
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.
