Microsoft Office Forums - View Single Post - How do you use the IF and AND function with numerouse amount of Data????

Thread: How do you use the IF and AND function with numerouse amount of Data????

View Single Post

Old

11-22-2013, 11:41 PM

Kevin@Radstock Kevin@Radstock is offline

Kevin@Radstock is offline

Kevin@Radstock uses Windows 8

Windows 8

Kevin@Radstock uses Office 2013

Office 2013

Office 365

Join Date: Feb 2012

Posts: 94

Kevin@Radstock is on a distinguished road

Default

Maybe something along these lines, in E6 and copy down.

=IF(B6<>"FT","",LOOKUP(D6,{0,1,2,4},{0,5,10,15}))

Reply With Quote