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...
excel
PReagan's avatar
PReagan
Bronze Contributor
Mar 10, 2020

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_Tucson's avatar
    Bill_In_Tucson
    Copper Contributor
    Mar 10, 2020

    Thank you PReagan, that did the trick.

    Cheers!

    - Bill

    PReagan 

    • PReagan's avatar
      PReagan
      Bronze Contributor
      Mar 10, 2020
      My pleasure!

Resources