Forum Discussion

Bill_In_Tucson's avatar
Bill_In_Tucson
Copper Contributor
Mar 10, 2020

VLOOKUP Drop Down Options For table_array

I am using VLOOKUP successfully but want to make the VLOOKUP call less cryptic. My application for VLOOKUP is in engineering calculations from data stored in a table named FET_Data. If I use "VLOOKUP(K5,FET_Data[#Data],6,0)" everything works fine. I noticed that when I've typed in "VLOOKUP(K5,FET_Data[" excel provides a drop down menu (see Drop.png). The selections at the top of the drop down are the titles of the columns in my table (e.g. RGATE, gM, etc). I'd like to be able to select the column using the column title rather than the 'col_index-num' . If I can do this, it makes my excel function look more like the formula that I am calculating; VLOOKUP(H17,FET_Data[#Data],6,0) vs VLOOKUP(H17,FET_Data[RGATE] . The problem is I haven't figured out how to complete the VLOOKUP instance using FET_Data[RGATE] and satisfy VLOOKUP syntax. I just get #N/A.

Resources