Hi,
On the spread sheet I have a table, with Level, unit range and value. When the number of units is entered in to B23, an IF formula gets the level it falls within (no problem here) and displays it in B26. Each level has a value, so in cell 29B I’m trying to use the LOOKUP function to display the value, basted on the info in B26.
Problem is the Lookup up function does not seam to work when looking up the level values with a number that has been general from a formula. If I type the level number in, it works fine.
I would be grateful for any help, spread sheet attached.
Bookmarks