Forum Discussion

AHMETDEMIR's avatar
AHMETDEMIR
Copper Contributor
Apr 13, 2020

Hi HCole718 ,

first of all thank you for your explanation, 

 

my request is very simple to explain,

 

when you changed D1 ( with another Kitchen Cabinet Brand ) D3 will not give an error !!!

that's what i want it ...

 

its giving an error now because of D1 section is working for only with selected brand price list !

 

if i can solve this problem, i can compare many brand price list in one excel sheet. 

 

please help me if you have a solution.

thank you for your help in advance!

best,

ahmet

 

HCole718's avatar
HCole718
Copper Contributor
Apr 13, 2020

Hello AHMETDEMIR 

 

Are using a Vlookup to get the price when you enter/change your cabinet item?

 

 

 

 

  • AHMETDEMIR's avatar
    AHMETDEMIR
    Copper Contributor
    Apr 13, 2020
    Yes, i use the Vlookup formula to get prices from each cabinet vendor's general price list.
    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Apr 14, 2020

      AHMETDEMIR 

      If you name all Tables the same way you may use formula like

      =VLOOKUP(B3,INDIRECT(D$1&"[#All]"),MATCH(CALCULATOR!$D$2,INDIRECT(D$1&"[#Headers]"),0),0)*C3

      Now it's the mix of Tables and Named ranges, I didn't find the data is structured, or at least I didn't understand how it is structured.

Resources