Hello All
(Please see attached)
In A6
If I enter any the values in row 1… it will return the text in row 2
Paul
Hello All
(Please see attached)
In A6
If I enter any the values in row 1… it will return the text in row 2
Paul
Like this:
Excel 2016 (Windows) 32 bit
A B C D E F 1 0 5 6 10 12 2 6 - 2 6 - 2 + Sat 6 - 2 + 2 - 10 6-2 + 2-10 + Sat3 Shifts 3 4 5 6 10.5 7 6-2 + 2-10 + Sat
Sheet: Sheet1
Excel 2016 (Windows) 32 bit
A 7 =HLOOKUP(A6,$A$1:$F$2,2,1)
Sheet: Sheet1
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
The values on row 1 are variable…
Return 6-2 = 5 or below
Return 6-2+sat = between 5 – 6
Return 6-2 + 2-10 + Sat = greater than 10 but below 11
I’ve managed to do this… I just don’t know I apply the other rules
=IF(A6<=5,"6-2")
try
=LOOKUP(A6,{0,5.00001,6.00001,10.00001,11.00001},{"6 - 2","6 - 2 + Sat","6 - 2 + 2 - 10","6-2 + 2-10 + Sat","3 Shifts"})
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
thats great, works well
Why not just change the values on row 1 as I demonstrated and use the HLOOKUP method???
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks