Ayal Telem
Member
Members
Power Query
Power Query
Forum Posts: 57
Member Since:
October 7, 2021
October 7, 2021
Offline
Hi,
I would like to return a value from a table based on 2 columns.
The file I uploaded has an example in the "Values" sheet.
Basically, upon entering the Nozzle and the Bar values in table "Calc", the relevant Vol/hr should be returned from table "Values".
Example: Nozzle=Brown; Bar=5.5 the formula should find the value "30".
Tried with Index and with XLookup but couldn't figure it out.
Any help will be appreciated.
Regards.
Ayal Telem.
Jessica Stewart
Northern USA
Member
Members
Trusted Members
Trusted Members
Forum Posts: 219
Member Since:
February 13, 2021
February 13, 2021
Offline
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Riny van Eekelen, Catherine Wiles
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1917
SunnyKow: 1432
Anders Sehlstedt: 900
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 290
lea cohen: 246
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Excel Learner
david gavi
Rick KISA
Jan Elenbaas
Ranjeet Wankhade
Sugata Maity
Karen McCarron
Amanda Zibell
Kevin Sanderson
wer klaus
Forum Stats:
Groups: 3
Forums: 24
Topics: 6880
Posts: 30156
Member Stats:
Guest Posters: 49
Members: 33700
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —