Hello Community,
I would greatly appreciate if some one could give me advice on how to fix a formula that I have written.
I am trying to write a lookup formula that searches data on a table on “sheet2” using two different parameters. I want to display the matched values found on the table in sheet 2 in “sheet1”. From online research, I have created the following function,
Where:
j4 &”I”&k4 = Cells where you would type the two different parameters in “sheet1”.
A4:d83 = Table where the data is located on “sheet2”
4 = The column on “sheet2” that contains the data to be displayed if matched on “sheet1”
The problem is that I need to “tell” excel to search sheet2 for the two different parameters typed on sheet1. I would also like to display the matched value on sheet1. Any other suggestions would also be greatly appreciated.
Thank you very much for the help.
I would greatly appreciate if some one could give me advice on how to fix a formula that I have written.
I am trying to write a lookup formula that searches data on a table on “sheet2” using two different parameters. I want to display the matched values found on the table in sheet 2 in “sheet1”. From online research, I have created the following function,
Code:
=vlookup( j4 &”I”&k4,A4:d83,4,false)j4 &”I”&k4 = Cells where you would type the two different parameters in “sheet1”.
A4:d83 = Table where the data is located on “sheet2”
4 = The column on “sheet2” that contains the data to be displayed if matched on “sheet1”
The problem is that I need to “tell” excel to search sheet2 for the two different parameters typed on sheet1. I would also like to display the matched value on sheet1. Any other suggestions would also be greatly appreciated.
Thank you very much for the help.
