Multiple VLOOKUP's in one formula?

[stevelucky]

There might be a much better way to do what I'm trying to do, but I sure as heck can't figure it out and am hoping that one of the professionals here can.

I have a cell, M1 in my sheet that needs to return 2 separate value from 2 different tables on another sheet.


So, cell M2 will look at cell H2 and then go to the sheet called "LookupTables" and when it finds that value in column AA (that value WILL definitely exist once in that column) of that sheet will return the value in the 2nd column over. So now, cell M1 on my original sheet is displaying the appropriate value from column AB of my LookupTables sheet.

Next, I want it to get that value of cell G2 of the original sheet and look for that value in column G of my LookupTables sheet. When it finds that value, it should return the value from the 3rd column over (column I). If there is no value in that column, it should return nothing. One of the tricky parts is that I would like these 2 separate returned values to be separated by a comma. So the returned value in cell M1 will either look like:

value1

or

value1,value2

Does that make sense or am I rambling? Any thoughts?

 

[Oluwasheyifunmi]

=VLOOKUP(INDEX(Enquiries_Refrence_List,A8),Enquiries_Refrence_Box,2,FALSE)
=VLOOKUP(INDEX(Complaints_Refrence_List,A11),Complaints_Refrence_Box,2,FALSE)
=VLOOKUP(INDEX(Requests_Refrence_List,A15),Requests_Refrence_Box,2,FALSE)
=VLOOKUP(INDEX(Products_Refrence_List,A19),Products_Refrence_Box,2,FALSE)

Hi all,
Good day first i'd like to say thanks to Aladin Akyurek for his reply. I have the following Vlookup formulas (stated above), I'd like to link everything to a cell (A5) however how do i ensure that only one of them can be active at once in the cell i want to link it to (A5)
For instance if i click anything from the source of the first formular, cell A5 should return only the first argument and igonre others
and if i click anything from the source of the second formula, cell A5 should return only the second argument and igonre others as well etc

Please help,thank you

 

[Aladin Akyurek]

=VLOOKUP(INDEX(Enquiries_Refrence_List,A8),Enquiries_Refrence_Box,2,FALSE)
=VLOOKUP(INDEX(Complaints_Refrence_List,A11),Complaints_Refrence_Box,2,FALSE)
=VLOOKUP(INDEX(Requests_Refrence_List,A15),Requests_Refrence_Box,2,FALSE)
=VLOOKUP(INDEX(Products_Refrence_List,A19),Products_Refrence_Box,2,FALSE)

Hi all,
Good day first i'd like to say thanks to Aladin Akyurek for his reply. I have the following Vlookup formulas (stated above), I'd like to link everything to a cell (A5) however how do i ensure that only one of them can be active at once in the cell i want to link it to (A5)
For instance if i click anything from the source of the first formular, cell A5 should return only the first argument and igonre others
and if i click anything from the source of the second formula, cell A5 should return only the second argument and igonre others as well etc

Please help,thank you

Activating a formula "by clicking" cannot be done with formulas. That requires VBA or something similar...

 

[David Wayne]

Ok so related to this issue of multiple vlookups in one formula; I have two vlookups that search a cell phone tower number (field O) and return the lats and longs in separate fields P and Q. This works great but next I need to lookup the cell phone tower number and a sector number in field R (usually between 1-3) which gives the azimuth value. Problem is for one cell tower there are 3 sectors that have very different azimuths. For instance,

Cellsite Latitude Longitude Sector Azimuth
2645 39.82954 -104.936974 1 320
2645 39.82954 -104.936974 2 95
2645 39.82954 -104.936974 3 235

I am trying to write a formula that will first look up the cell site number ie 2645 then the corresponding sector (eg 2) and return the azimuth of 95. This formula is to be used for several thousand phone records. Any ideas??? Please HELP!!!

 

[Aladin Akyurek]

Control+shift+enter, not just enter:

=INDEX(AzimuthRange,MATCH(SectorValue,IF(CellSiteRange=CellSiteValue,SectorRange),0))

 

[David Wayne]

Nope; this didnt work at all!! Any other thoughts.

 

[Aladin Akyurek]

Nope; this didnt work at all!! Any other thoughts.

That doesn't provide much information. How did you implement this?