Posts by Chris Collins7

2 posts shown.

Microsoft Office Q&A: Ask anything (Word, Excel, PowerPoint, etc.) in Software · Apr 21, 2012

Kyle Johnson2 said:try using this formula: =LOOKUP(B5,Sheet2!A1:A241,Sheet2!B1:B241)
Basically, the Lookup function takes two main arguments

can you send over an example file?
here's my file. Pay close attention to the data range base (Sheet2)

fixed the issue using
Code:

=LOOKUP(B5,{"200-240";"250-290";"350-390";"400-440"},{"1,152";"1,414";"1,937";"2,199"}))

→ go to post

Microsoft Office Q&A: Ask anything (Word, Excel, PowerPoint, etc.) in Software · Apr 20, 2012

Hey there
I need some help with a LOOKUP function.
I built this formula using nested IF statements, but I'm trying to switch over to LOOKUP—only it keeps throwing an error because of those hyphens.

This works fine:
Code:

=IF(B5="200-240",1.152,IF(B5="250-290",1.414,IF(B5="350-390",1.937,IF(B5="400-440",D5,2.199))))

But this one doesn't🙂
Code:

=LOOKUP(B5,{"200-240","250-290","350-390","400-440"},{1.152,1.414,1.937,2.199})

If anyone knows how to fix this, let me know.
Thanks

→ go to post