Formula Help.

[CCHolden]

Hi,

I'm having a hard time getting a formula to work, and hoping someone here can point me in the right direction. Below is part of the sheet I'm working with.

If for example column A is 10, I need the cell with the formula to be populated with £2.07. I've tried many variations of greater and lower than formulas, but nothings working.

Sorry for the lack of detail in the title, I have no idea what this problem might be called.

Thank you in advance!

 

[Fluff]

How about

=XLOOKUP(A2,$L$2:$L$13,$N$2:$N$13,"",-1)

 

[CCHolden]

Thanks for coming back to me. I'm just getting #NAME? now.

 

[Fluff]

Are you using 365 as per your profile?

 

[CCHolden]

I've fixed this now, thank you so much for your help!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[CCHolden]

Actually I do have one more question. Im trying to now add this formula on to the end of a IF formula. I've tried & but its not working.

 

[Fluff]

What is you formula?

 

[CCHolden]

=IF(I16="yes",SUMIFS(Book1!$J$60:$J$232,Book1!$E$60:$E$232,C16,Book1!$F$60:$F$232,D16,Book1!$G$60:$G$232,E16),0)

=LOOKUP(AD16,Book1!C61:C232,Book1!J61:J232)

 

[Fluff]

Are you trying to add the xlookup to the false part of the IF instead of the 0?