Adding a number to a calculated number (1 or 2) based on a range.

[gofetch2023]

Hello! I need a formula to read column A (no. of bundles) and search the range in columns C & D and then add the whole number from column E to the number in column A. Test.xlsx

I usually use VLOOKUP, but am having a difficult time adding the whole number to it.

[josephteh]

Try, =XLOOKUP(A2,$E$2:$E$13,$F$2:$F$13,0,1,1)+A2, assuming add 0 if value > 5.99.

[Pete_UK]

You could use this formula in B2:

=IF(A2="","",A2+VLOOKUP(A2,$C$2:$E$13,3))

then copy down.

Hope this helps.

Pete

[josephteh]

Sorry, should be =XLOOKUP(A2,$D$2:$D$13,$E$2:$E$13,0,1,1)+A2

[gofetch2023]

Both of these worked. Thanks for your help!

[Pete_UK]

You're welcome - thanks for the rep.

Pete