| Edit: Split from [Solved] What formula use with INDEX/MATCH? because the table layout has been changed. New problem → New topic. |
[Solved] What formula to use for table lookup?
-
Olegs Andrejevskis
- Posts: 3
- Joined: Fri Apr 02, 2021 10:14 am
[Solved] What formula to use for table lookup?
- Attachments
-
- Prices formula_2.ods
- (18.83 KiB) Downloaded 89 times
Last edited by MrProgrammer on Sun Apr 18, 2021 7:25 pm, edited 1 time in total.
Reason: Tagged ✓ [Solved]
Reason: Tagged ✓ [Solved]
OpenOffice 3.4.1 on Windows 10
-
MrProgrammer
- Moderator
- Posts: 4905
- Joined: Fri Jun 04, 2010 7:57 pm
- Location: Wisconsin, USA
Re: What formula use for table lookup?
[Tutorial] The SUMPRODUCT function, example X16Olegs Andrejevskis wrote:What would be better formula for getting prices from this layout?
If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the subject field. Select the green checkmark icon at the same time.
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).