Forum Discussion
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.
3 Replies
- PReaganBronze Contributor
Hello Bill_In_Tucson,
If your table starts in column A, then that could be like:
=VLOOKUP(H17,FET_Data[#Data],COLUMN(FET_Data[RGATE]),0)- Bill_In_TucsonCopper Contributor
- PReaganBronze ContributorMy pleasure!