[Solved] LOOKUP question
[Solved] LOOKUP question
I'm looking for a lookup formula (i'm assuming it's a lookup formula) to get the corresponding ranking to match the numbers in column B (see attachment). The formula would go in column H. Thanks
- Attachments
-
- sample_lookup.ods
- (11.02 KiB) Downloaded 56 times
Last edited by rsc78 on Mon May 23, 2016 1:33 am, edited 1 time in total.
OpenOffice 4.0.1
Windows 8
Windows 8
- MrProgrammer
- Moderator
- Posts: 4907
- Joined: Fri Jun 04, 2010 7:57 pm
- Location: Wisconsin, USA
Re: LOOKUP QUESTION
[Tutorial] VLOOKUP questions and answers
If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.
If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can 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).