Hello:
I have cell Cell P1 = 1
I need formula in cell Q1 to give column # based on value in cell P1 as follows.
If P1 = 1 then Column will be "O"
If P1 = 2 then Column will be "S"
If P1 = 1 then Column will be "W"
If P1 = 1 then Column will be "AA"
and so on....every 4th column
Please let me know if you have any questions.
Thanks.
Riz
Hi,
One way
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Hm, may be I understand it a bit different way, because Richard's approach will lead to the same as:
Formula:
Please Login or Register to view this content.
May be the answer is:
Formula:Please Login or Register to view this content.
Or may be:
Formula:Please Login or Register to view this content.
Best Regards,
Kaper
Hello Richard and Kaper:
Thanks a lot, both solution works
Riz
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks