ExcelBanter - Function Help

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Function Help (https://www.excelbanter.com/excel-programming/367931-re-function-help.html)

Wahine

Function Help

Thank you.

"MattShoreson" wrote:

or you could use choose.

=CHOOSE(MATCH("x",A2:G2,FALSE),A1,B1,C1,D1,E1,F1,G 1)*H2

--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=563626

All times are GMT +1. The time now is 11:30 PM.